For example:
Average Time on Site is 00:05:58
but it comes into Excel as 357.812313003452
To convert it properly, use the formula =A2/60/24/60
Don’t forget to format the cell format as “hh:mm:ss”
For example:
Average Time on Site is 00:05:58
but it comes into Excel as 357.812313003452
To convert it properly, use the formula =A2/60/24/60
Don’t forget to format the cell format as “hh:mm:ss”
You have discusses incredible points that post good, keep up the great work.