Solved In Excel, How to convert total hours into days + hours

February 24, 2013 at 23:23:12
Specs: Windows 7
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.

See More: In Excel, How to convert total hours into days + hours

Report •


#1
February 25, 2013 at 04:02:55
✔ Best Answer
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.


Report •

#2
February 26, 2013 at 02:32:46
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!!!

Report •

Related Solutions


Ask Question