Sarah,

Another possibility is that you have formatted the cells as time, and there is a date/time in one of
the cells, but it is only showing the time. Try formatting all the cells for number / decimal, and
see if any are greater than 1.

HTH,
Bernie
MS Excel MVP


"Sarah" wrote in message
...
I am sorry that is what I meant - 12:30pm

"Joel" wrote:

Lunch in time is 12:30 am instead of 12:30 PM

"Sarah" wrote:

I have created a time card where employees choose from a drop down box what
time the started, time they left for lunch, returned for lunch, and then left
to go home. I have the time in the following columns

C D E F G
16 Time In Lunch Out Lunch In Time Out Total Hours Worked

I have the following function in G16:
=IF(((D16-C16+(C16D16)+F16-E16+(E16F16))*24)8,"ERROR - Please check your
hours.",((D16-C16+(C16D16)+F16-E16+(E16F16))*24)).

the purpose it to not allow employees to enter more than 8 hours per day and
make them enter a time for all four cells. However we are getting errors for
such things as:
C D E F
16 8:15am 11:30am 12:30am 5:15pm

Please advise.