Calculate time if greater than specific time in excel?


Re: Calculate time if greater than specific time in excel?
The screenshot is too small and fuzzy. Please attach a sample workbook instead.

Re: Calculate time if greater than specific time in excel?
Dear AliGW,
Please find attached workbook.

Re: Calculate time if greater than specific time in excel?
What EXACTLY are you trying to calculate? Is it the SUM of the times in column N, or each individual time? Because I can't see any that are anywhere near 72 hours.

Re: Calculate time if greater than specific time in excel?
I want to calculate how many times the duration exceed72:00:00 ?
If possible if the duration exceed it can be written “YES or“No” if no. 

Re: Calculate time if greater than specific time in excel?
OK  thanks for the clarification.

Re: Calculate time if greater than specific time in excel?
Do you know a way to do it ?

Re: Calculate time if greater than specific time in excel?
This will do the calculation in O2 copied down:
=IF((K2J2)>4,"Yes","")
However, you will get no yes returns, as none of the time differences exceed 72 hours.

Re: Calculate time if greater than specific time in excel?
I try it, it didn't work
I copy the formula into cell O2 
Re: Calculate time if greater than specific time in excel?
It does work, it's just that you don't have any values that match.
Which rows do you expect to return YES and why?


Re: Calculate time if greater than specific time in excel?
Ok I will check it again, I tested it on one sheet but maybe your correct there is no time exceed 72 Hours.


Re: Calculate time if greater than specific time in excel?
Quite simply, 72 hours = 4 days.

Re: Calculate time if greater than specific time in excel?
Ok noted, thanks for the help.

Re: Calculate time if greater than specific time in excel?
You're welcome!


Re: Calculate time if greater than specific time in excel?
Sorry  just realised it should be 3, not 4! 72 hours = 3 days. Please adjust in the formula.

Re: Calculate time if greater than specific time in excel?
Ok I will edit the formula, Thanks again for the help.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!