Recording Clock In and Clock Out

Charlene Stacy

We use a sheet with a form accessed through a QR code to Clock In and Clock Out. The problem is that to figure out the calculation the sheet is downloaded to an Excel spreadsheet and calculated to determine how many hours each person recorded on the time sheet. Is there an add-on or any solution available in smartsheet that is already designed that can calculate the time worked based on a simple clock-in and clock-out process?

Paul Newcome

There is a TIME function.

TIME Function | Smartsheet Learning Center

https://help.smartsheet.com/function/time

Returns the time of day in 12- or 24-hour format from a given set of values.

Paul Newcome

There is a TIME function.

TIME Function | Smartsheet Learning Center

https://help.smartsheet.com/function/time

Returns the time of day in 12- or 24-hour format from a given set of values.

Norringtonm

can you share more about the setup of this? I’d love to build a clocking in/out system for a company that has employees in the field to replace manually kept paper