Link to home
Start Free TrialLog in
Avatar of surah79
surah79

asked on

Excel Conditional formating for HH:MM:SS

Hi guys

I am subtracting two time fields which are in HH:MM:SS format and want to higlight if anything which is smaller -00:15:00 in the column L.
I have selected teh date system as of 1904 so that I can see the -ive value.
Basically subtracting two time values and highlight any value which is smaller than -00:15:00.
Please find attached the sample sheet.

thanks a lot for help
Test_ConditionalFormating.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial