If I understand you, try:

=IF(A1<=TIME(2,30,),"No delay","")

or:

=IF(A1<=2.5/24,"No delay","")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Donna" wrote in message
...
Hello all.

I need help with an if function that will result in No Delay if Total Time
is less than or equal to 2:30 (two hours, thirty minutes). My total time
column is formatted as --[h]:mm in the event we have a total time of over
24
hours.

Example:
Total Time Reason for Delay
E4(cell number) 2 :30 No Delay

Any suggestions?

Many thanks.

Donna