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)
Thanks Hans, but that didn't work, but I don't think I explained it fully enough. I have columns: date, start time, end time, hours worked (which can vary), total hours (which is the sum of all hours worked). I then need the next column to give 'total days worked' where the 'total hours worked' is divided by 7 hour days.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?