Round Time Cards to 5, 6, or 15 minutes

When adding up time cards, it is often alot easier to round time to the nearest 15 minutes (quarter hour), 6 minutes (1/10th hour), or 5 minutes (1/12th hour), depending on how you do the math - converting to decimal before or after adding all values.

The charts below explain how to round time to the nearest 5 minutes, 6 minutes or 15 minutes.

If the time to round is greater than or equal to the time in the left column, and it is less than or equal to the time in the middle column, then round the time to the value in the right column. Substitute the current hour in the time you are rounding for HH.

Generally, the same rounding rule applied to a time card must be applied to both the punch in and punch out times.

Round Time To Nearest 5 Minutes (1/12th Hour)

 If time is >= HH:MM:SS If time is <= HH:MM:SS Round Time To HH:MM:SS HH:57:30 (round up to next hour) HH:02:29 HH:00:00 HH:02:30 HH:07:29 HH:05:00 HH:07:30 HH:12:29 HH:10:00 HH:12:30 HH:17:29 HH:15:00 HH:17:30 HH:22:29 HH:20:00 HH:22:30 HH:27:29 HH:25:00 HH:27:30 HH:32:29 HH:30:00 HH:32:30 HH:37:29 HH:35:00 HH:37:30 HH:42:29 HH:40:00 HH:42:30 HH:47:29 HH:45:00 HH:47:30 HH:52:29 HH:50:00 HH:52:30 HH:57:29 HH:55:00

Round Time to Nearest 6 Minutes (1/10th Hour)

 If time is >= HH:MM:SS If time is <= HH:MM:SS Round Time To HH:MM:SS HH:57:00 (round up to next hour) HH:02:59 HH:00:00 HH:03:00 HH:08:59 HH:06:00 HH:09:00 HH:14:59 HH:12:00 HH:15:00 HH:20:59 HH:18:00 HH:21:00 HH:26:59 HH:24:00 HH:27:00 HH:32:59 HH:30:00 HH:33:00 HH:38:59 HH:36:00 HH:39:00 HH:44:59 HH:42:00 HH:45:00 HH:50:59 HH:48:00 HH:51:00 HH:56:59 HH:54:00

Round Time to Nearest 15 Minutes (1/4th Hour)

 If time is >= HH:MM:SS If time is <= HH:MM:SS Round Time To HH:MM:SS HH:52:30 (round up to next hour) HH:07:29 HH:00:00 HH:07:30 HH:22:29 HH:15:00 HH:22:30 HH:37:29 HH:30:00 HH:37:30 HH:52:29 HH:45:00

Round Time Automatically

Spectrum TimeClock supports rounding time when employees punch in.

Find out more about our web based time clock software.