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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History