Automatically Calculate Start and End Times Using Hours

Overview

Sometimes your data may be in a format where you only have the total hours worked, but in order to use Smart Formulas, a start_time and end_time are required.

UpSheets allows you to define a default start_time that is used to generate the required start_time and end_time automatically.

For example, if your file has the following three lines:

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 your default start_time to 06:00am, the following will automatically be generated when validating the file:

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

Setup

To enable this feature, you must first enable Smart Formulas in your user settings.

The below setting will then be available and you can set the desired start_time:

startHour

When validating your file, only the hours column is required in your file:

start_hours_validate

The start_time and end_time will be gererated automatically:

start_time_upload