Skip to main content

View Latest

New Delhi31°C
Time, dates and shifts

Hours and minutes calculator

Hours and minutes calculator

Add and subtract a list of hour-and-minute entries and get the net total, the hours on one side, the hours on the other and the decimal figure underneath.

How this is calculated

Every entry is converted to minutes, signed, and summed. The total is divided back into hours and minutes, and days only where the figure exceeds 24 hours.

  • A negative net total is shown with a minus sign rather than turned into a positive balance, because the two mean different things on a timesheet.

A running total of hours, minus the leave taken, is the shape most attendance sheets actually have. Enter each entry as hours and minutes, mark it add or subtract, and read the net figure.

Minutes are carried, not truncated

Entering 90 in the minutes box is treated as an hour and a half, not as an error and not as thirty minutes. Every entry becomes a whole number of minutes before anything is added, so the total is the same whether you write a shift as one row of 8 hours 30 or as three rows of 2 hours 50.

That conversion is also why the decimal line exists. A payroll system that wants 43.75 hours and a supervisor who wants 43h 45m are asking for the same quantity in two notations, and a sheet that shows only one of them starts arguments.

What the negative case means

If the subtracted entries exceed the added ones, the net total is shown with a minus sign and the day line says the time is owed. A balance of -6h 30m is a shortfall against a target, not a period to be paid.

Whether a shortfall can be carried forward, set off against overtime or has to be taken as unpaid leave is a condition of employment. The arithmetic here gives the size of it and nothing else.

Questions readers ask

Can I add fractional hours directly?

Type them in the minutes box instead. 0.25 of an hour in the hours column and 0.5 in the minutes column both work, but a quarter-hour entered as 15 minutes is unambiguous and one entered as 0.25 is easy to misread later.

Is there a limit to how many entries?

Six rows. A month of daily entries belongs on the time card calculator, which keeps a date against each line and prints a day-by-day sheet.

Does it round anything?

No. The whole total is exact down to the minute, and rounding to the nearest quarter hour is a practice some employers apply to clock times and others forbid. If a rounding rule governs your sheet, apply it to each entry before adding rather than to the total afterwards — the two give different answers.

Tools

More in Time, dates and shifts

Time and date calculators

Hours worked, elapsed time, the gap between two dates, working days and shift totals.