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

If Function With A Time
 

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


Replace @mailinator.com with @tiscali.co.uk


"Donna" wrote in message
...
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 Function With A Time
 

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

If Function With A Time
 

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" wrote in message
...
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 Function With A Time
 

Thanks so much.
--
Donna


"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Donna" wrote in message
...
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 Function With A Time
 

Thanks so much.
--
Donna


"robzrob" wrote:

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