View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna Donna is offline
external usenet poster
 
Posts: 180
Default If Function With A Time

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