Forum Discussion
Solved
conditional formating with time (hours)
I have three columns, first one with break time out and second with break time in. The third have to show the difference and if it is grater than one hour it has to show in red text. times are entere...
Denjg I'd recommend you to enter the times with a colon rather than a decimal point. That turns them into real time values without the need to convert them first. Then it will look like this:
with conditional formatting in Excel for the Web:
Note that 1 hour is represented by the numerical value of 1 / 24 = 0.04166667
