conditional formatting 24-hour clock
 

Am trying to apply conditional formatting to columns of times. The numbers
are in 24-hour clock format - 00:15:23.
I would like to bold the times that are less than 15 minutes.
Entering in 00:15:00 as the"less than" amount hasn't work. When i do it
anyway.

Thanks for all advice.
jb

"snitz" wrote:

Am trying to apply conditional formatting to columns of times. The numbers
are in 24-hour clock format - 00:15:23.
I would like to bold the times that are less than 15 minutes.
Entering in 00:15:00 as the"less than" amount hasn't work. When i do it
anyway.

Thanks for all advice.
jb


Hi,

Set Conditional Formatting like this ,
Formula is, =IF(MINUTE(D28)<15,TRUE,FALSE)


Regards,
Marc

Hi!

Assume the times are in the range A1:A10.

Select the range A1:A10
Conditional Formatiing
Formula Is: =A1<15/1440

Biff

-----Original Message-----
Am trying to apply conditional formatting to columns of
times. The numbers
are in 24-hour clock format - 00:15:23.
I would like to bold the times that are less than 15
minutes.
Entering in 00:15:00 as the"less than" amount hasn't
work. When i do it
anyway.

Thanks for all advice.
jb


.

See Biff's answer. Comparison on the Minute component will not work because
it will only show 5 minutes for 15:05:30 (15 hours + 5 minues +30 seconds).
and that number certainly exceeds 15 minutes.

for more information on Date and Time see
http://www.mvps.org/dmcritchie/excel/datetime.htm-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm