Weekly Time Card

What is the Weekly Time Card?

The Weekly Time Card is a place to view all of your employee's time card totals for a particular week. This is meant to give you a high-level view of your employee's time cards.

This view allows for:

Auditing time cards for your company
Exporting totals to then load into your payroll system.

Different metrics can be viewed (see below for more information) and filters can be applied. You can also download the table to a CSV file and open it in Excel (or your preferred spreadsheet program).

What does the date selection do?

Once a date is selected, the table will show the date selected and 6 days after. The column headers in the table will display which dates are being viewed.

The default date selected is your company's last start of the workweek date. The start of your workweek is a company setting. For example, if your start of the week is on a Monday, the default date is the most recent Monday to today.

What are the metric options?

These metrics are pretty much the same as you'd find on the Daily Time Card, with a few additions.

Labor Time - total clock time minus any give time. Generally considered being the person's "paid time".
Clock Time - the total amount of time the person is clocked in
Travel Time - total travel time, including commute
Work Time - total work time
Lunch Time - total lunch time
Standby Time - includes the time from Standby and Clocked In
Holiday, Sick, Vacation Time - totals for respective metric
Commute Time - the actual commute time
Commute Start of Day - portion of the actual commute that was at the start of the day. Any travel that was before the first work of the day is considered, not including Travel Home.
Commute End of Day - portion of the actual commute that was at the end of the day. Any travel at the end of the day before the clock out OR marked as Travel Home is considered.
Commute Give Time - the amount of time that the person has to give (unpaid usually) to the company for their commute.
After Hours - the total amount of time the person is clocked in as "After Hours".

How do I change formats (hh:mm:ss to hours)?

Simply click the "Change Format" button on the top right of the table to change the format of the table. NOTE: The format is remembered so each time you come to the page, it will be the same as you last had it.

Below is an example with the same information but formatted in hours.

What is the total column?

The total column sums up each date that is visible into a single total column. This helps see a total view for each person for that metric.

How are the totals calculated?

Sometimes it may seem that the total when viewed as hh:mm:ss is different than the hours format.

For example, the two screenshots above show 41:49:27 and 41.84.

For hh:mm:ss 41:49:27, we clearly have 41 hours. 49 minutes x 60 seconds per minute + 27 seconds = 2967 seconds.

2967 seconds / 3600 seconds per hour = 0.82416667 + 41 hours = 41.82416667

41.82416667 does not equal 41.84, even when rounded.

The difference: adding seconds and then converting to hours versus converting to hours then summing up the hours

So how do we get 41.84? It is the sum of each individual day's hours. From the example above, 0.00 + 8.59 + 9.31 + 7.90 + 8.04+ 8.00 + 0.00 = 41.84

So how do we get 41:49:27? It is the sum of each individual day's hh:mm:ss. From the example above, 00:00:00 + 08:34:58 + 09:18:05 + 07:54:00 + 08:02:04 + 08:00:00 + 00:00:00 = 41:49:27