Forum Discussion
Solved
total work days from accumulating total work hours
Hi. I'm trying to find the formula which calculates total work days (of 7 hours) from column D (which gives a running total of hours worked), but which also avoids a problem of when 24 hrs is reached...
If you want a result such as 3.4 or 4.2:
=24*[@[Total PROJECT time]]/7
If you want whole days only:
=INT(24*[@[Total PROJECT time]]/7)
I changed the number format so that times > 24 hours are displayed correctly.
What would be the expected result in column G?
I want column G to display number of working days. This is based on the total number of project hours divided by 7 hour days.
If you want a result such as 3.4 or 4.2:
=24*[@[Total PROJECT time]]/7
If you want whole days only:
=INT(24*[@[Total PROJECT time]]/7)