I am trying to calculate the average and total time in a site. I have tried using the datediff and dateparse functions. Datediff did not work because because I only have the total time in the booth. I have searched the knowledgebase and forums but have not found a suitable solution.
Let me know if additional information is needed. I have attached a packaged workbook.
Thanks.
Hi Jeffrey,
One small step to do...right-click the d:h:mm:ss field and then select Default Formatting. Select, Custom. In the box, enter 0:00:00:00 for d:hh:mm:ss and the display values should update. Do the same for the Avg.
If this answers your question please mark as Best Answer or if helpful please Upvote. Because email notifications aren't working properly in the forums, please use @Don Wise with your response/reply so that I see notifications. Best, Don
