Hours to working days

[VCC35]

Hi All, I'm struggling to generate data of the numbers of days it takes to complete a task.

Assuming if a task takes 25 hours to complete,i am trying to calculate how many days to allocate to a resource, so based on a 8 hour work day, i need it to show as 3 days 1 hour is there a way of doing this?

 

[saboh12617]

Hello,
I hope this "overengineered" formula helps you understand the calculous. In B1 the total hours, and in B2 the hours/day.

=LET(
totH, B1,
HpDays, B2,
nbDays, TRUNC(B1/B2),
HLeft, MOD(B1,B2),
SWITCH(nbDays, 0, "",1, nbDays &" day ", nbDays, nbDays&" days ") & SWITCH(HLeft, 0, "",1, HLeft &" hour", HLeft, HLeft&" hours"))

 

[VCC35]

Hello,
I hope this "overengineered" formula helps you understand the calculous. In B1 the total hours, and in B2 the hours/day.

=LET(
totH, B1,
HpDays, B2,
nbDays, TRUNC(B1/B2),
HLeft, MOD(B1,B2),
SWITCH(nbDays, 0, "",1, nbDays &" day ", nbDays, nbDays&" days ") & SWITCH(HLeft, 0, "",1, HLeft &" hour", HLeft, HLeft&" hours"))

Thank you, thats perfect