How many yrs/month/day h:mm:ss are xxx hours when you use 4 hours per day

[mathkkad]

I would very much appreciate if you could help me to gather a formula on this issue:

Let`s say i have a number of hours like 213 hours 29 minutes 0 seconds, meaning 213:29:00 in a excel cell (but it can vary it can be 1246:32:00 hours or 12:00:00 hours and so on)
How can i get how many years/months/days/hours/minutes/seconds it will take to use them in a constant rhythm of 4 hours per day (or 6 hours per day or 8 hours per day)
Maybe you know how to make a formula where i can vary the input of number of hours and the constant rhythm of watching per day and get a end result format of years/months/days/hours/minutes/seconds "0y 0m 0d 0:00:00"

example:

Input (hours): 3:00:00 / Rhythm (hours per day): 04:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 0d 3:00:00
Input (hours): 4:00:00 / Rhythm (hours per day): 04:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 0:00:00
Input (hours): 5:00:00 / Rhythm (hours per day): 04:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 1:00:00
Input (hours): 7:00:00 / Rhythm (hours per day): 04:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 3:00:00
Input (hours): 8:00:00 / Rhythm (hours per day): 04:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 2d 0:00:00
and so on...

Input (hours): 5:00:00 / Rhythm (hours per day): 06:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 0d 5:00:00
Input (hours): 6:00:00 / Rhythm (hours per day): 06:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 0:00:00
Input (hours): 7:00:00 / Rhythm (hours per day): 06:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 1:00:00
Input (hours): 11:00:00 / Rhythm (hours per day): 06:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 5:00:00
Input (hours): 12:00:00 / Rhythm (hours per day): 06:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 2d 0:00:00
and so on...

Input (hours): 7:00:00 / Rhythm (hours per day): 08:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 0d 7:00:00
Input (hours): 8:00:00 / Rhythm (hours per day): 08:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 0:00:00
Input (hours): 9:00:00 / Rhythm (hours per day): 08:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 1:00:00
Input (hours): 15:00:00 / Rhythm (hours per day): 08:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 1d 7:00:00
Input (hours): 16:00:00 / Rhythm (hours per day): 08:00:00 / Time to complete (in years/months/days/hours/minutes/seconds): 0y 0m 2d 0:00:00
and so on...

Can you please help me find a formula that gives an answer in this format 0y 0m 0d 0:00:00
Thank you!

[gue2013]

Please Login or Register  to view this content.

it is not possible to calculate months or years as long you have no start date but only hours!
depending on the month you have 28 to 31 days and for years you have 365 or 366 days.

cheers

[mathkkad]

Thank you very much for the reply, i will look into it