Skip to content
OfficeOpenToday

Hours calculator

An hours calculator counts hours between two clock times, then adds every day on the sheet. Nine a.m. to five p.m. is eight hours. The clock starts in 12-hour form; 24-hour is a toggle. Overnight rows treat an earlier end as the next morning. Unpaid lunch minutes come off that day before the total.

Hours timesheet

Sheet

Fill

File

Date Start End Lunch Night Hours
Total 8 hours

Count hours

Need to add two durations instead? Time calculator.

Hours calculator FAQ

How many hours between 9:00 a.m. and 5:00 p.m.?

Eight hours. That 9 to 5 workday is the default on this hours calculator, so you can read it with scripting off. Switch the clock to 24-hour if you prefer 09:00–17:00.

Can I add more than one day?

Yes. Add a day, this week (Monday–Sunday with dates), or the weekdays of this month. Each row has a calendar date and a day name. The answer is the running total.

How do I calculate hours overnight, like 10 p.m. to 6 a.m.?

Turn on Night on that row. The end time is treated as the next morning, so 10 p.m. to 6 a.m. is eight hours.

Can I save or print a timesheet?

Save keeps the dated sheet in this browser. Load saved brings it back. CSV includes the date column. Print uses the browser print dialog. Those actions need scripting; the default Monday 9 a.m.–5 p.m. answer is still in the HTML.