Time Spent and Elapsed Time

Time Spent and Elapsed Time

Hi,

I am extracting some data into Power Bi and I can convert the unix date for such fields as created time but I am not having any luck with fields such as Time Spent or Elapsed Time.

What would be the SQL statement to convert this to regular time?

Regards,

Tom

                  New to ADSelfService Plus?