That formula will do the reverse what Sarah wanted, it will return an error
if it less than 8 hours and it won't work if the start time is before
midnight and the end time is after midnight



--
Regards,

Peo Sjoblom




"Joel" wrote in message
...
Sarah: Try this. delete all space in cells and delete AM and PM. If it
is
really time format removing the Am and PM will c ause excel to put them
back
automatically.

=IF(AND(D16C16,E16D16,F16E16,24*((D16-C16)+(F16-E16))=8),24*((D16-C16)+(F16-E16)),"ERROR
- Please check your
hours.")

"Sarah" wrote:

It won't bring up "ERROR..." any more?

"Peo Sjoblom" wrote:

It can be shortened to

=IF(MOD(F16-C16,1)-MOD(E16-D16,1)"08:00","ERROR, Check your
hours",(MOD(F16-C16,1)-MOD(E16-D16,1))*24)

format as general

however I tested your formula and it works so the dropdown results must
be
wrong

--
Regards,

Peo Sjoblom

"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.