timesheet calculation formula

In Sheet Trial cell L15, copy down: =IF(A15="","",IF(AND(C15="Saturday",E15<>"PH"),MAX(H15-5/24,0),0))

Hi sir, thank you very much for helping me out, i really appreciated..

the 1st formula is work for my Microsoft 2013, because PH not only on Saturday..
but, there still got a bit problem (even if the red, blue and green words is successfully works)..
the problem is, work after 6pm..
the formula get me total hours with deduct 1hr Lunch Break on OT 2.0,
let say 8am to 6pm, total working hours is 9, the 1st 8hrs only will pay on OT 2.0

example work 8am to 6pm, working hours = 9hrs,
then, OT 2.0 = 8hrs, and OT 3.0 = 1hr

** but for this case, i had solved the formula (adjust manually), but not in the perfect formula
template 13.01.2025.xlsx

Change OT2.0 formula to: =IF($A15="","",IF($E15="PH",IF($H15<=5/24,$H15,MIN($H15-1/24,8/24)),0))
And, OT3.0: =IF($A15="","",IF($E15="PH",IF($H15<=9/24,0,$H15-9/24),0))

Check Clock Out times, e.g. cell G38, it's entered as 01/01/1900 8:00:00 AM, that's 8:00 AM the next day, so total working hours is 24 hours, not 0.

You should format Working Hours in this format: [h]:mm ("h" in square brackets).

Goodday Sir, deeply apologies for late reply..

Just now i had try the formula that you give and also changed the format as your advised..
its extremely amazing, and well functioning

and the problem (2) also solved after i rnd with all your formula..
1st time i work with time formula, its new experiences for me..

I am so grateful for your time and effort to monitoring me..
I really adored with your talent
Thank you very much for your guidance and support..

You are welcome. Thanks for the feedback, Rep and for marking the thread Solved!