Forum

Paul Sheppard
@shep
Active Member
Joined: Jan 20, 2021
Topics: 1 / Replies: 6
Reply
RE: Work Time Calculation

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...

4 years ago
Reply
RE: Work Time Calculation

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...

4 years ago
Reply
RE: Work Time Calculation

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 ...

4 years ago
Reply
RE: Work Time Calculation

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...

4 years ago
Reply
RE: Work Time Calculation

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...

4 years ago
Reply
RE: Work Time Calculation

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...

4 years ago
Topic
Replies: 11
Views: 74