Here's a complicated problem. I can't change the format of the current
timesheet. The overtime is calculated by taking the total hours worked
and subracting 8. This is fine, but two things break it. 1) When less
than 8 hours are worked to compensate, and 2) when an entire shift is
overtime. These are two really big things that should have been fixed
when the timesheet was first made.

Anyways, I have been working on fixing the problem. So far, I have
created a way of correcting problem #1. I have a running total. If the
total is 0, then OT is displayed, else 0 is displayed. Actually
working overtime breaks this, too, though. Then you end up with both
the shifted OT displayed and the actual OT displayed.

A third problem that arose: It is a Bi-weekly timesheet and OT is
calculated weekly. How would I tell the spreadsheet was a week is? I
can't change Sheet1, so I am just planning on pointing to it in other
sheets. Thanks in advance.

matiez