time issue

[iwzhidden]

ok i want to take the time =Now() that is on I32 . If it is greater than 15 mins cell I27 will turn RED . If it is less than 15 minutes it will turn green.

cell I32 8:30pm
cell I27 9:00pm <---------- cell will turn red

cell I32 8:30pm
cell I27 6:00pm <---------- cell will turn green

thanks for your help.. getting their slowly..

[Colin Legg]

Hi,

Use conditional formatting.

This formula will return TRUE if the time difference is greater than 15 minutes and it will return FALSE if the time difference is equal to or less than 15 minutes:
=MOD(I33-I32,1)*1440>15

Colin

Edit: Re Post #3 - Thanks Dav, you are correct. I have amended the conversion factor from 1400 to 1440.

[Dav]

I think the 1400 is 1440 (24hrs x 60 minutes), if the above is ammended accordingly it should work

Regards

Dav

[iwzhidden]

what I am trying to do is on the driver sheet the appointment time fill in the cell on page 6.23.08 cell J2(if the time is before the time or same time) on the driver sheet I27 it will put the time in with Green TIME. If it is later than the time it will be red..

[arthurbr]

Hi,
as you have not adapted your title as requested, I am closing this thread.
Please feel free to open a new one with a relevant title

Cheers