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 (which is an issue I've only read about).
Hope this is enough detail.
Thanks in advance.
Antony
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)
Simply use a formula such as =SUM(D2:D32) and apply the custom number format [h]:mm to the cell with the formula. The [ ] around h instruct Excel to display the hours as duration instead of as clock time.
- 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?
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...
