If formula for Time

A

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
 
B

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 th
trash time, and reset it to 1800 if it is larger than 1800, otherwis
it will keep the cell as it appears
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top