How the working hours calculator works
Each row represents one working day. The calculator takes the out time minus the in time; if the out time is earlier than the in time it assumes the shift crossed midnight and adds 24 hours, which is how a 20:00 to 08:00 security post or a 22:00 to 06:00 factory C-shift is handled. Unpaid break minutes are subtracted from that duration.
Daily totals are shown as hours and minutes and as decimal hours, because payroll systems multiply decimal hours by an hourly rate. Forty-five minutes is 0.75 hours, not 0.45. The weekly total is compared with 48 hours, the ceiling used by the Factories Act and most Shops and Establishments Acts in India, so hours above that line are flagged as potential overtime.
- Use 24-hour times such as 09:15 or 21:40 for every entry
- Enter only unpaid breaks; a paid tea break should stay inside working hours
- Leave a row blank for a weekly off or holiday and it is ignored
- Copy the decimal total into a salary sheet or timesheet
Why decimal hours matter for Indian payroll
Most disputes about hours come from mixing formats. A supervisor writes 8:30 meaning eight and a half hours, the payroll clerk types 8.30 into Excel, and the employee is underpaid by twelve minutes a day, which is six hours a month across a 26-day roster. Converting once, at the point of capture, removes that error.
Indian overtime is normally due beyond nine hours in a day or 48 hours in a week, at twice the ordinary rate for factory workers under the Factories Act and the Code on Wages. Knowing the exact daily and weekly duration is the first step to calculating that premium correctly, which the overtime pay calculator on this site handles.