Hi!

Try this:

A1 = 6:00 AM
B1 = 2:30 PM

=IF(COUNT(A1:B1)<2,"",B1-A1+(B1<A1)-TIME(0,30,0))

Subtracts 30 minutes for lunch, break, whatever.

Biff

"OSSIE" wrote in
message ...

what i need to know its how many hours the person worked i mean like if
they came in 6 am the ens shift its 2:30 pm and the next cell would
have the answer as 8 hrs or for my night shift they come in at 14:00
and dont leave till 10:30 taht woudl give me again the 8 hrs or
whaterver hours they work hope i explain better thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=524580