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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.