Automatically Calculate Start and End Times Using Hours
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
- Enable Smart Formulas in Settings.
- 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.
