conditional formatting and difference in time

[Time to Learn]

Want to create a conditional format for a cell when the difference in time worked vs scheduled is greater than 2 hours. Thank you.

[dredwolf]

This assumes hours worked in column a, hours scheduled in column b (or vice versa), and that the times are time values:
=ROUND(ABS(A5-B5)*24,10)>2

the ABS subtracts the 2 times and converts result to a positive number
*24 converts the hours to integers
The round(..,10) makes sure stray round off errors dis-appear
and >2 checks the result against 2, if the resltis larger than 2 it returns TRUE, otherwise it returns FALSE

Hope this helps

[Kevin UK]

Hi Time to Learn

May be!
A1 = Start Time & A2 = End Time

Please Login or Register  to view this content.

[Time to Learn]

Thank you.