Help In Excel RRS feed

  • Question

  • Hello, Everyone! I am Making sheet of attendance but I have some trouble to complete it. I want to calculate overtime and short time but there is already error. can any one help me my working hours is 9 hours from 10:00 to 19:00

    Total Time (=C18-B18)

    Overtime (=D18-N17

    Short Minutes (=N17-D18)

    D18 is total time and N17 is 9:00 B18 is Time Inn and C18 is Time Out

    Friday, January 5, 2018 12:58 PM