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!

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.

Thank you, that worked great!

Ask Your Question

Weekly Poll