If Function With A Time

[Donna]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[robzrob]

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 over24
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","")

 

[Rick Rothstein \(MVP - VB\)]

Given the name of your column "Reason for Delay", I have to ask what else
can go into this column besides the words "No Delay" and how does it get
placed there... user types it? from another formula? some other way?

Rick

 

[Donna]

Thanks so much.
--
Donna

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

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

 

[Donna]

Thanks so much.
--
Donna

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","")