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.

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

    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.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login