Hi Lionel Thanks for your patience in sorting this out for me I have put your latest formula into my spreadsheet to the beginning of the year an...
Hi Lionel Once again many thanks for your help I have used your new formula with my data, back to the beginning of the year, it was all ok until...
Hi Lionel I have just put the formula in my spreadsheet, back to the start of the year and found a problem with entries that are on a Saturday and ...
Ok thanks Lionel, just checking there wasn’t a reason for your doing that way. Thanks again for the solution, it will save many hours of work every m...
Hi Lionel Thank you that is perfect I struggle with time calculations in excel, so have been looking at your formula and whilst I could not have...
Hi Lionel That is great thank you Is it possible to adapt that formula so that if the start time is out of work hours (between 17:01 & 08:59...