|So your data looks like this, I have included the Column Letters and Row numbers that you seem to have forgotten about.|
A B C D E F G H I
1) Date: Time In: Time Out: AM Hours Time In: Time Out: PM Hours RegularTotal HRS Over
2) 01/11/2016 08:30 AM 12:00 PM 3.5 1:00 PM 5:00 PM 4 7.5 0.5
Is there a specific reason you have separated out the AM Hours and the PM Hours?
You can shorten your sheet by two columns if not.
There is no reason to use the SUM() function on a single cell in this formula:
For the formula in cell H2 try this:
For the formula in cell I2 try this:
message edited by mmcconaghy