LinkBack URL
About LinkBacks
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.
Want to create a conditional format for a cell when the difference in time worked vs scheduled is greater than 2 hours. Thank you.
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
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi Time to Learn
May be!
A1 = Start Time & A2 = End Time
Formula:
=MOD(A2-A1,1)>2/24
Last edited by Kevin UK; 03-17-2013 at 08:03 AM. Reason: Point out cell values A1 & A2
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks