Using Start Time and End Time instead of Hours

Most file formats require a column for Hours in order to upload data, but it is also possible to provide a Start Time and End Time column and have UpSheets calculate the hours automatically.

To do so, select the Enable Start/End Times option on the Import screen when importing your file:

start_end

On the following screen make sure you select columns for Start Time and End Time. You may optionally also select a column for Hours* which will be used if the Start Time and End Time are not set.

times

If all fields are provided, the Start Time and End Time will be used instead of Hours