Working Hours & Overtime Calculation In Excel - Time Sheet in MS Excel

Download file from the below mentioned link

https://docs.google.com/spreadsheets/...

My Channel
   / @uexcelinmsoffice4323  



"Working
Hours" 8 "Hourly
Rate" $20.00 "Over Time
Rate" $30.00

Date Day "Login
Time" First Break Snacks Break "Logout
Time" Total hours Total Pay
Start Time End Time Start Time End Time
12-08-2024 Mon 9:05 AM 1:05 PM 1:40 PM 4:10 PM 4:35 PM 6:05 PM 8.00 $160.00
13-08-2024 Tue 8:43 AM 1:03 PM 1:42 PM 4:28 PM 4:49 PM 6:27 PM 8.73 $182.00
14-08-2024 Wed 8:28 AM 12:46 PM 1:28 PM 4:01 PM 4:25 PM 6:04 PM 8.50 $175.00
15-08-2024 Thu 9:12 AM 1:12 PM 1:52 PM 4:22 PM 4:31 PM 7:01 PM 9.00 $190.00
16-08-2024 Fri 8:56 AM 12:57 PM 1:47 PM 4:05 PM 4:29 PM 8:59 PM 10.82 $244.50