On Aug 6, 9:26*pm, Donna wrote:
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


=if(E4<0.1049,"No Delay","")