If exporting the Interaction view as a CSV file to use with Excel don't select the Format Durations checkbox
Use the following formula to convert the duration in milliseconds to a day fraction .... stay with me on this :)
= A1 / (1000 x 60 x 60 x 24)
Where A1 is cell with milliseconds time value
1000 is the milliseconds in a second
60 is the seconds in a minute
60 is the minutes in an hour
24 is the hours in a day
Apply a time format to the value to display it as hours minutes and seconds.
An advantage of doing all this is you can add, subtract, multiple and divide the values too.
Note: you can substitute 86,400,000 for 1000 x 60 x 60 x 24 , but I remember it as the individual terms
Go a step further and automate the transformation using Excel's Power Query
------------------------------
Jonathan Bartelt
Advocate Aurora Health, Inc.
------------------------------
Original Message:
Sent: 09-06-2023 11:00
From: Julien HAZARD
Subject: Time format without milliseconds
Hello,
Is there a way to have time format without milliseconds when extracting datas from interactions ? I just need hours, minutes and seconds.
Thanks
#Reporting/Analytics
------------------------------
Julien HAZARD
Nordnet
------------------------------