Hi
E1=MIN(10/24,(D1-A1)-(C1-B1))
F1=MAX(0,(D1-A1)-(C1-B1)-10/24)
formatted as "hh:mm"
or
E1=MIN(10,((D1-A1)-(C1-B1))*24)
F1=MIN(0,((D1-A1)-(C1-B1))*24-10)
formatted as General or Numeric
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"Chris" wrote in message
...
I am trying to create a spreadsheet to calculate hours worked. I need to
know
what formulas to use to calculate the time in hours and overtime hours.
for
example:
A1= 6:00 am start time
B1= 11:15 am start lunch
C1= 11:45 am end lunch
D1= 17:00 pm end time
I need E1 to reflect total hours worked to a maximum of 10 hours/day and I
need F1 to reflect overtime time hours in excess of 10 hours/day.
E1= 10.00 regular hours worked
F1= 00.50 overtime hours worked
PLEASE HELP!
|