Calculation of duration in hh:mm during pre-defined time range

I've created formulas for all colomns except sundays..

when there are time tresholds it is easier to test them in min or max formulas combined with if

one of my comments was also all times needed to be true times but I see that is already solved..

Thank you very much Roel! That"s perfect

---

If that takes care of your original question, & to say Thanks and for better Motivation, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
   then
2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.

YEs I have added reputation already

One more question before I close the thread, what would be the formula for worked hours between 6:00am and 8:00am ?

Kind regards,

I have added a column at the end for that requirement.

Also I saw later column D and E have header Weekday. does this mean they do not need to calculate if weekday is Saterday or Sunday.
Just in case this is so I build in this version a variation of the earlier formula that will exclude sat and sun from the calculation of time in col D and E.

see attachment.

Dear Roel,

Thanks again very much for your kind help.

In the column I3 of your file, the result should be 1:13 instead of 0:47 (The person has worked 1:13h between 6 and 8 am). I tried to change the formula but I could not manage to make it work.

Sorry for the lack of clarity in my original request.

Kind regards,

Your request was clear, I just confused myself my first try I had 1:13 and then decided to change is..
Calculating with time and time windows is often a bid of a puzzle.

At least you now have most all possibilities in one sheet for future reference