Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I compare time differences in Excel?
I am trying to track my employees break times and if they are going when they are supposed to. I work for a customer centric industry so they will not be exact but I don't want them going whenever they want. I have to ensure that enough people are always available for the customers.
If column A is their scheduled break time and column B is when they actually went, what formula could I enter in column C to indicate the difference. I'm using "h:mm" formating if that's important.
Ex: Column A: 20:45, Column B 19:58 OR 20:59.
I can do the equation if they are late to break but if they go early, I get an error.
1 Answer
- quietfredLv 58 years agoFavorite Answer
3 possible outcomes - left early, late, or didn't leave yet
if didn't leave b3 will be blank and c should be blank
if left early a is greater than b so subtract b from a
if left late b is greater so subtract a from b
formula is:
=IF(OR(ISBLANK(A3),ISBLANK(B3)),"",IF(A3>B3,A3-B3,B3-A3))
