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:
When validating your file, only the hours column is required in your file:
The start_time and end_time will be gererated automatically:
