conditional formatting 24-hour clock

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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>
Click to expand...


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
 
Back
Top