With the help of a number of posts on the forums, I've taken a large dataset and been able to evaluate the total time, within a range of days, pool cars have been used. What I'm now struggling with is to calculate the hours used as a percentage of a "working day"
eg;
Car One used for 04:20:00 hours, what percentage use is this against a working day of 07:00:00?
Do I need to calculate this out in seconds and convert back or is there another way?
Thank you.