it may just be me but in none of those examples posted above or the workbook do you give an example of the answer you are expecting, you've shown example data but havent said that in example A I would expect 05:00 hours or example C works out at 3:00 hours.
Can you confirm that my example above is correct?
Also, is it possible to have part hours?
Bookmarks