If Function for Time Calculation

  • Hi guys, whatsup?
    Can anyone tell why formulas in column G don't work please?
    Can anyone figure it out?

    What I need is the following:
    if the first login is earlier than the shift time to make the tardiness 0
    if the first login is after the shift time to calculate the difference in minutes

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


    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!