# Calculate time if greater than specific time in excel?

• Hello,

I would like to know how can I calculate if time in Duration cell is greater than 72:00:00 Hours ?

Note: The formula I used for Duration is:

Code
``=TEXT(K2-J2,"hh:mm:ss")``

## Images

• Re: Calculate time if greater than specific time in excel?

The screenshot is too small and fuzzy. Please attach a sample workbook instead.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• Re: Calculate time if greater than specific time in excel?

Dear AliGW,

## Files

• 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.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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((K2-J2)>4,"Yes","")

However, you will get no yes returns, as none of the time differences exceed 72 hours.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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?

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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?

Why in the formula we put 4 ? Because I think I should put the value of 72:00:00 Hours to be as rule instead of number 4 which I don't understand what it represent.

Code
``=IF((K2-J2)>4,"Yes","")``
• Re: Calculate time if greater than specific time in excel?

Quite simply, 72 hours = 4 days.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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!

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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!