If Function With A Time

D

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
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
R

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
Click to expand...


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

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
 
D

Donna

Thanks so much.
--
Donna


Sandy Mann said:
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk


Donna said:
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
Click to expand...
Click to expand...
 
D

Donna

Thanks so much.
--
Donna


robzrob said:
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
Click to expand...


=if(E4<0.1049,"No Delay","")
Click to expand...
 
Top