Forum Discussion

FatihaYahya93's avatar
FatihaYahya93
Copper Contributor
Feb 08, 2023

How to calculate accurate overtime.

Hello, I dont know how to explain my problem, but I hope there would be any solution for this. I am working on a overtime schedule, but it is inaccurate on TOTAL (N), TOTAL (O) and on DEDUCTED (P) columns. The calculation on DEDUCTED column should accurate after deduction from N and O. Here I put the document and you can take a look on the formulas Ive been used and suggest better solution. Please refer formulas on those 3 columns. You may suggest accurate formulas for this matter.

https://docs.google.com/spreadsheets/d/1qthEayBqGiipdq2xMKbIdVAnROxFacbk/edit#gid=253312993 

Formulas and Functions

7 Replies

    • FatihaYahya93's avatar
      FatihaYahya93
      Copper Contributor
      Feb 08, 2023
      ive changed the settings, can you view it? if possible, can you change the time check out to 11:00 am or earlier than that? you will see the inaccuracy i meant..

      https://docs.google.com/spreadsheets/d/1qthEayBqGiipdq2xMKbIdVAnROxFacbk/edit#gid=253312993
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 09, 2023

        FatihaYahya93 

        Thanks. I understand column N, but not columns O and P.

        Can you explain what you want to calculate in column O and in column P?