I get 7:30

=D1-A1-(C1-B1)

where D1 is end, A1 is start, C1 is lunch end and B1 lunch start, that will
return 05:30 formatted as hh:mm then

=F1-E1

where F1 is flex end and E1 flex start, that gave me 02:00

then totaled gave me 07:30



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Gwynn" wrote in message
...
I have a payroll worksheet which houses an employee's start time, lunch
start/stop and end time. It also notes any Flex-time for an employee. In
these cells I enter the time for each (in military). Under the first
column,
start...end I have a total. Under Flex time...start/end...I have a total.
To get the total hours worked I am trying to sum the regular total and
flex
total but the sum is incorrect.

Any suggestions?

START TIME 8:30
LUNCH START 11:00
LUNCH STOP 11:30
END TIME 14:30
Total Time 5.50

Flex-time (2 hours minimum/max)
Start 15:00
End 17:00
Total 2:00

Total Hours worked 14:00 <<<--- This is what is not adding correctly.