Start-Date End-Date Duration
3/1/2019 10:24:00 AM 8/17/2019 1:11:00 PM 950:36:00
3/2/2019 10:11:00 AM 8/17/2019 1:05:00 PM 944:00:00
Data format are in:
Dates are in Custom m/d/yyyy h:mm
Duration is in Time 37:30:55
When I upload this data into Power query
Duration column with Date/Time format - its loaded as
If I change this to Duration format - it errors saying 2/8/1900 2:36:00 PM couldn’t be converted error