Re: Timesheet: Calculate Overtime Rates crossing into next day
Thank you very much for the help
I was able to use the formulas you provided and create a version of the sheet compatible with Excel 2003 upwards.
Here's a copy in case it is of use to anyone. It is protected with editable cell ranges hidden formula cells, but no password has been set if you wish to explore.
Regular time and Overtime time values can be changed through Name Manager (2007, 2010), or through Insert > Name > Define (2003)