Forum Discussion
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)
Thanks, see the attached version.
- Hi Hans, thanks, I see you have amended the formula in total project hours, but this was already working ok ( to my knowledge). It is the 'Total days worked' in column G which is where I'm struggling...
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.
