Hi Mark,

Am Tue, 17 Nov 2020 04:10:45 -0800 (PST) schrieb NoodNutt:

One of the issues with the time is that some of the employees work past midnight, and given there is no Date column for each Start & Finish, I shortcut it by extending the time past 24.00, so if someone Started @ 14:00 and Finished @ around 2:00, I would enter the Finish time as 26:00; it still calculates to 10.00 hours.

This means this: "If IsNumeric(Target) And Target <= 2359 Then" needs to be more like: "If IsNumeric(Target) And Target <= 2800 Then" to cater for anyone working to 4.00am.

I sent you an email


Regards
Claus B.
--
Windows10
Office 2016