Thread: How to change colors to time values
View Single Post
 
Old 02-01-2021, 09:14 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Make one of the formulae:
=AND(MOD($B2,1)>=9/24,MOD($B2,1)<=17/24)
and the other:
=AND(MOD($B2,1)>17/24,MOD($B2,1)<1)
[actually, that second formula can be simplified to =MOD($B2,1)>17/24, untested]


edit post posting: Oops. I've just noticed the attached file was Arvi's and not the OP's! Sorry. And it would help if I read the question properly! Updated.
Attached Files
File Type: xlsx msofficeforums46427LocalTime.xlsx (12.2 KB, 7 views)
Reply With Quote