If Function for Time Calculation

  • The result in the formula in F3 is yielding a date/time combination, so it will always be larger than the time only cell, E3.


    Try this version:


    =IF(E3<MOD(F3,1),0,F3-E3)


    Note: Please use correct/relevant forums to ask your questions in for better results. (this question should go in the Excel Formulas forum).

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Although I don't understand the login or how it works
    but your formula works like a magic
    thanks a million


    usually I face hard times with times and dates formulas actually :)

Participate now!

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