Get Mystery Box with random crypto!

A common task is counting working hours over a period of time. | Excel Today



A common task is counting working hours over a period of time. If we know the time of the beginning and end of the working day and the number of days, then everything is simple. Multiply the days by the duration of the working day.

But if there is a date and time of the beginning of the calculation and the date and time of the end, then the task becomes more difficult. It is necessary on the day of commencement and on the day of termination to take into account only those hours that were working (and the counting can begin and end in the middle of the working day). Yes, and the weekend is also need considering.

Read more about the ranges in the article