Time Log Export

[RickyP]

Making use of the TIME LOG EXPORT.

I love the time log function in Chief but have suffered so much frustration with totaling up the exported times in Excel.

There are occasions where I wanted to summarize times with sub totals for stages etc, and Excel just will not play ball with the exported data regardless how you export it from Chief or import it to Excel.

The answer is, don't use Excel use Google Sheets.

Export from the Time Log as a .txt file and open it in a Google Sheet.

You need to tell Google Sheets not to Auto Detect data type by selecting the radio button that tell it to just import data as text.

You will see the values of each line's time has not been converted into some gibberish that Microsoft thinks you want, but just a value exactly as it appears in the Time Log.

Click on the "Time Elapsed" (third column "C") column header to select the entire column.

Go to "Format" and click, select "Number" and click, select "Time Duration" 13th row down, and that's it.

You can now use simple "SUM" functions just like Excel to subtotal and total time etc.

 

If anyone has trouble with the instructions, please drop me a line.

 

Cheers,

Rick

Edited November 26 by RickyP
Added more information