If formula for Time

[Ad]

Hi,

Anyone know how to use if formula to to set Time criterial? What I'm trying
to do is to set a formula to convert the time back to the time limit set.
For example, if my trash hold for time is from 9am-6pm, any time clock
outside 6pm (eg 8pm) should be converted back to 6pm.

Is there way to get this done?

Cheers,
Ad

[bgeier]

If I understand you correctly, you would use

=if("A1" > 1800,1800,"A1")

this will look at the cell, determine its value, compare it to the trash time, and reset it to 1800 if it is larger than 1800, otherwise it will keep the cell as it appears.

[Bob Phillips]

=MAX(MIN(A1,TIME(18,0,0)),TIME(9,0,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bgeier" <[email protected]> wrote in
message news:[email protected]...
>
> If I understand you correctly, you would use
>
> =if("A1" > 1800,1800,"A1")
>
> this will look at the cell, determine its value, compare it to the
> trash time, and reset it to 1800 if it is larger than 1800, otherwise
> it will keep the cell as it appears.
>
>
> --
> bgeier
> ------------------------------------------------------------------------
> bgeier's Profile:
http://www.excelforum.com/member.php...o&userid=12822
> View this thread: http://www.excelforum.com/showthread...hreadid=544191
>