Thread: Time Conditional Formatting
View Single Post
 
Old 03-09-2021, 07:40 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Time is just a fraction of a day, so 19:00 is 0.7916667 of a day.

then conditional format to that number (roundings may casue a problem)
Attached Files
File Type: xlsx Time Conditional Formatting_purfleet.xlsx (10.4 KB, 6 views)
Reply With Quote