Exporting a csv file with time formatting

JobBag does not do hours and minutes in a decimal format as it leads to severe rounding issues. Instead we do everything in hours:minutes (hh:mm).

When you export data from JobBag that has a field that contains time (like a timesheet listing or job reports that have hours:minutes, Excel by default does not recognise the time field and won’t calculate the results correctly when you apply a formula to the field. You need to format the field so that Excel recognises it as a field with hours and minutes.

Select the cells or column that contains the time fields, then select Format Cells. Click on Custom then create the format [h:mm].

This will allow you to sum the time fields.

Step 1        Export the csv file Step 2        Create a new column. Step 3        Multiply the imported hours figures by 24

Step 4        Change format of new column to General - you now have 10.25 hrs

Step 5        You may wish to reformat the original imported column to remove the seconds