timesheet formula

  • Thread starter Thread starter lilcliffy
  • Start date Start date
L

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
 
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
 
Back
Top