Can I Set a Common Duration Format for Spreadsheet Exports?

Question: Several of my spreadsheet exports use a different duration format, so it makes it difficult to compare values across reports. Is there a way to set a common duration format for spreadsheet exports? Starting January 1, 2017, all spreadsheet exports (e.g., scheduled reports, exported reports) will use a common duration format for stop time, idle time, and so on (see below for columns affected). If you are importing report spreadsheets with Excel or macros, you will see changes to column headings and duration formatting that will affect your import processes. Prior to this standardization effort, spreadsheet exports used varied duration formats for different report types. Using a consistent format for all exports ensures a more accurate way to compare data between multiple reports. Using the User Preferences icon, you can choose the format that you want to use: If you do not set a preference, the default setting is…