To get hours over 40 using time format

=MAX(D1-"40:00",0)

if you are using integers replace "40:00" with 40

for 40 and lower

=MIN(--"40:00",D1)

--
Regards,

Peo Sjoblom

(No private emails please)


"jennerifw" wrote
in message ...

I've already figured out how to enter employee's time, but now I want to
have it return anything 40 hours and below into one cell and all hours
over 40 into another. Any ideas?


--
jennerifw
------------------------------------------------------------------------
jennerifw's Profile:
http://www.excelforum.com/member.php...o&userid=26071
View this thread: http://www.excelforum.com/showthread...hreadid=394076