Feb 08 2023 02:36 AM - edited Feb 08 2023 02:37 AM
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
Feb 08 2023 03:34 AM
I get "Access Denied". You need to share the workbook.
Feb 08 2023 06:31 PM
Feb 09 2023 04:05 AM
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?
Feb 09 2023 06:34 PM - edited Feb 09 2023 06:40 PM
column N = deduction from check in and start break.
column O = deduction from end break and check out.
column P = total of N and O (this is because i need to subtract the break time, cannot use basic formula as i need to set overtime 24 hours).
Actually, i found out the formula is accurate if i check in on 8:30 am and check out on 3:00 pm and upwards, however, the calculation will be false if i check out 12:00 pm and downwards. Would love to know the exact way to make everything correct.
Feb 10 2023 03:46 AM
Does the attached version work for you?
Feb 12 2023 05:08 PM
Feb 13 2023 01:25 AM