Forum Discussion
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) co...
I get "Access Denied". You need to share the workbook.
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
https://docs.google.com/spreadsheets/d/1qthEayBqGiipdq2xMKbIdVAnROxFacbk/edit#gid=253312993
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?
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.Does the attached version work for you?