Timesheet: calculating overtime in Texas

**GuardianTX** · 04-30-2010, 03:02 PM

Hi, I am running into a problem with my timesheet and calculating overtime in Texas. I am trying to transition from California Timecard management to Texas. The overtime doesnt seem to work right with this sheet. I inherited this from my predecessor.

=ROUND(IF((OR(C24="",D24="")),0,IF((D24<C24),((D24-C24)*24)+24,(D24-C24)*24))+IF((OR(F24="",G24="")),0,IF((G24<F24),((G24-F24)*24)+24,(G24-F24)*24)),2)

**DonkeyOte** · 04-30-2010, 06:19 PM

It might help if you explain what the issues are as you see it (based on the sample data).

Assuming anything above 8 hours is deemed OT (irrespective of weekday) then the file appears to work correctly.

Remember the greater majority of us will be unaware of the potential significance of the below:

Originally Posted by GuardianTX

I am trying to transition from California Timecard management to Texas

so try to be as detailed as possible - ie assume we know nothing

Though FWIW you could perhaps "simplify"/shorten the formulae to:

I12: =24*SUM(MOD(D12-C12,1),MOD(G12-F12,1))
J12: =MIN(8,I12)
K12: =I12-J12

I12:K12 copied down for all rows.

**GuardianTX** · 05-06-2010, 11:32 AM

Thanks so much, I greatly appreciate it.

From what I have been asked, we are trying to set the timesheet to not calculate overtime by day, just week. We are also trying to add a PTO Column since holiday is being managed as itself. Any help would be very much appreciated.

Thanks