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

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


"Donna" <Donna.DeleteThis@discussions.microsoft.com> wrote in message
news:045A72D5-E55E-4B5D-8516-7640A508A4E4@microsoft.com...
> 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
>

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" <Donna.TakeThisOut@discussions.microsoft.com> wrote in message
news:045A72D5-E55E-4B5D-8516-7640A508A4E4@microsoft.com...
> 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

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
>
> sandymann2 RemoveThis @mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "Donna" <Donna RemoveThis @discussions.microsoft.com> wrote in message
> news:045A72D5-E55E-4B5D-8516-7640A508A4E4@microsoft.com...
> > 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
> >
>
>
>

Thanks so much.
--
Donna


"robzrob" wrote:

> On Aug 6, 9:26 pm, Donna <Do... RemoveThis @discussions.microsoft.com> 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","")
>