Forum Discussion

CarolMonzillo's avatar
CarolMonzillo
New Contributor
3 years ago

Remove days from excel spreadsheets.

When exporting a report to excel, the total time of a report is in the format 18d 20:30:50.  Convert this to a number that Excel understands so arithmetic is simple.