Forum Discussion

Jessssssssss's avatar
Jessssssssss
Copper Contributor
Jan 08, 2025

Conditional formatting time

good morning.

 

i have it set up in my spreadsheet to highlight anything over 15 minutes (time is entered as 0:15) and its working fine.

 

but it is also highlighting everything that is 0:00 and i can't figure out to exclude these so is there a different formula to use?

 

currently i am using 

 

=L11>time(0,15,0)

  • What happens if you format the cells with the times as General or as Number?

    Are all values less than 1 or are there values greater than or equal to 1?

Resources