Shift hours calculator
Calculate net shift durations, including overnight shifts, from a timesheet export.
Your results
Shift hours calculator
Review the net duration of shifts exported from a timesheet, including shifts that cross midnight. Supply start and end times with unpaid break minutes. The result helps check recorded time before a separate payroll calculation.
How to use this tool
- Choose a file, drag it into the upload area, import a public file URL, or paste your text below the upload options.
- Review the settings and create your result.
- Download and check the output before using it.
Supported input formats
CSVTSVTXT
Output and limitations
Calculate net shift durations, including overnight shifts, from a timesheet export.
Required headers: employee,date,start,end,break_minutes. Dates use YYYY-MM-DD; times use 24-hour HH:MM. An end before the start means the next day; equal times mean zero hours. Uses wall-clock minutes, not timezone or daylight-saving adjustments, payroll rates or overtime rules. Upload a UTF-8 file up to 5 MB or paste up to 12,000 characters. An uploaded file takes priority. Up to 10,000 rows and 100 columns. Formula-like spreadsheet cells receive a protective apostrophe.
Where are my files processed?
Selected files are processed in your browser. Importing a URL uses the download service to retrieve the remote file.
What if processing fails?
Check the supported formats and file limits, then try a smaller file. Keep an original copy. A clear error message will explain an unsupported input or an unavailable processing service.