This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Reporting export to excel - Time\Duration value

Hi,

I had a look at the remote access report, and on the gui it shoes the login date\time and then a duration which is in the format hh:mm:ss. I exported the report to excel, and the duration field is shown as a string of numbers. example: duration in gui says 07:46:38, and excel string is 27998. How do i convert this to show the duration. I tried a simple format change on the column, but got a wildly incorrect value. I added a decimal to the beginning, but that only converted to 06:43:10.

 

Regards

Sean



This thread was automatically locked due to age.