timesheet formula

[lilcliffy]

I want to total u pmy hours on a spreadsheet i made that includ
overtime. So like one week if there is only a total of 37 hours i
would take away only 3 hours from my alloted OT and make 40, I have go
it to take away from my OT slot but it adds the whole thing instead o
just up to 40 hours. Can someone PLEASE help me

 

[Dave R.]

Can you clarify why you want to add (or take away) 3 hours of overtime if
you haven't worked a 40 hour week?

I think you can use principles from this thread in your solution:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=dce3a997ee109
3d2&rnum=16

 

[lilcliffy]

Well my office uses Flex time, meaning overtime gets piled up and take
whenever possible, this amount of time is in a cell that i add time t
when time is allotted for. I want to and 2 weeks together and if thei
sum is less than 80 add time from my flex time cell but not to be mor
than 80 hour