Only if a time is larger than a different time so how larger it is.

  • Hi


    I have an excel document full of my employee's working hours. Their normal shift is 8 hours. Occasionally it is a bit less, occasionally it is a bit more.


    I would like to have a formulae saying; that if the employee does greater then the 8 hours how much extra they have done.
    I do not want the days that are lower than 8 hours to be involved in the calculation


    I hope that you can help me. Thanks

  • Re: Only if a time is larger than a different time so how larger it is.


    It would be beneficial if you uploaded a sample worksheet so that we can see what you have and need. Don't load a picture as many users are not able to see picture attachments. Make sure that there are enough records that are representative of your actual worksheet.