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.