If Function With A Time

  • Thread starter Thread starter Donna
  • Start date Start date
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
 
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 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","")
 
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
 
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

(e-mail address removed)
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...
 
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...
 
Back
Top