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”