Add a column when exporting the Job Details report to a CSV that converts the time worked per employee to a decimal.
Currently it shows the time worked in the format "hours:minutes". So, for a time worked of 2 hours and 45 minutes would show as "2:45". While this may make it easy to understand for someone who is only interested in reading the report, it makes things way more difficult and highly inefficient for someone like me who is using the report to calculate the amount of money spent on labor per job. Excel automatically converts this format to a time of day which makes it impossible to convert to anything else within Excel so I'm left going through every employees hours per job and manually converting them to a decimal myself.
HAYDEN BAARDSEN
shared this idea
JT Abbott
responded
Hey Hayden, you can change your preference of decimal time or hours/minutes on ClockShark by going to Admin > Company Settings.
If you want hours/minutes on the site, but decimal on the report you could create a quick macro that would add a new column and do the conversion for you!