Convert Hours to Days and Hours

[JennOlsen]

Hello,

I'm trying to design a quick calculator for taking a number of hours and converting it to two separate numbers to reflect the equivalent days and hours.

C5 should show only the amount of days.
C6 should show any remaining hours.

The supplementation hours needs to be divided by the number in D4.

Can this be done?

[John Vergara]

Hi JennOlsen!

[C5] : INT(D2/D4) 
[C6] : =D2-C5*D4  

Blessings!

[FlameRetired]

For days use this.

Please Login or Register  to view this content.

for Supplemental hours I don't understand the rational for the "The supplementation hours needs to be divided by the number in D4." part.

What it looks like you want will be returned by rounding up like this

Please Login or Register  to view this content.

[JennOlsen]

Hi. I'm calculating "work days/hours", and some people do not work a full day, so to convert it, I need it to be full day equivalents based on the number of hours they work. Not a 24 hour period or a standard 8 hour work day. The hours can be up to one decimal point. So 2.4 would be correct in my sample.

EDIT: I think having the formula for the Days, I can use a simple sum calc to get the hours remaining.

[6StringJazzer]

The actual number of hours in D2 is 91.91, so your sample result is incorrect. Do you want to round this number to the nearest hour? Round it up to the next highest hour? Not round at all?

Attached are solutions for all.

[FlameRetired]

...........
EDIT: I think having the formula for the Days, I can use a simple sum calc to get the hours remaining.

Please share the formula you used. BTW thank you for marking your thread Solved.