If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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(E40.1049,"No Delay","") |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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(E40.1049,"No Delay","") |
Thread Tools | |
Display Modes | |
|
|