Default Start Time - UpSheets

Automatically calculate start and end times from hours

Sometimes your data only has total hours worked, but Smart Formulas need a start_time and end_time. UpSheets can use a default start_time to generate both automatically. For example, if your file has:

full_name	date	hours
John Smith	01/01/2024	1
John Smith	02/01/2024	2.5
John Smith	03/01/2024	8.25

If you set the default start_time to 06:00, validation will generate:

full_name	date	hours	start_time	end_time
John Smith	01/01/2024	1	06:00	07:00
John Smith	02/01/2024	2.5	06:00	08:30
John Smith	03/01/2024	8.25	06:00	14:15

IMPORTANT: Xero has no concept of start and end times. The times UpSheets generates for Smart Formulas are never sent to Xero and are only used for calculation.

Setup

Select Settings from the menu and enable Smart Formulas.
Select the Timesheets tab and enter the desired Start Hour.

When validating your file, you only need to select the Hours column. The start_time and end_time are generated automatically when you validate it.

start_time_upload — Start time setting for Smart Formulas