Forum Discussion
Re: total work days from accumulating total work hours
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...
3 Replies
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)
