I need to convert a total number of hours into number of days (a day being 24 hours) and remaining hours into 2 diff cells. For example A1=2085 (this is the total of hours). I would like B1= to show total of days, and C1 = to show remaining hours. Answer should be B1=86 days, C1=21hours. I need a formula to do this automatically for me.

The Integer function INT() strips off the decimal portion of a number. Days: =INT(A1/24)

Hours: =(A1/24-INT(A1/24))*24

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

Wow!!! Your answer worked like a charm. Thank you, thank you, thank you kindly!

I spend hours trying all sorts of things (with simple arithmetical formulas) and I couldn't get passed that "days" cell. It was giving me 87 days because Excel was rounding it up to nearest value (upping it up in this case). You guys are just awesome!!!

Ask Your Question

Weekly Poll

Do you think smart refrigerators will catch on?

Discuss in The Lounge

Poll History