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

​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  Read More

​