Solved How to shorten the minutes displayed for a formula

March 7, 2017 at 07:00:42
Specs: Windows 7
I am using this formula that I found on an older discussion: =INT(B3-A3)&" Days "&MOD(B3-A3,1)*24&" Hours"

Is there a way to shorten the minutes field to 2 digits?

Thank you!


See More: How to shorten the minutes displayed for a formula

Report •

#1
March 7, 2017 at 07:46:31
✔ Best Answer
I don't see a "minutes field" so I assume you mean the decimal portion of the "Hours" value. Assuming that is correct, try this:

=INT(B3-A3)&" Days "&ROUND(MOD(B3-A3,1)*24,2)&" Hours"

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 9, 2017 at 07:33:01
Thank you, that worked great!

Report •
Related Solutions


Ask Question