Forum Discussion

bbrauer100's avatar
bbrauer100
New Member
10 years ago

Time to Duration conversion throws an error.

I'm trying to convert time of day to duration in order to perform summary calculations.  However, when I try to convert time to duration in Query Editor the following error occurs:     DataFormat....
wonga's avatar
wonga
Continued Contributor
10 years ago

Hey Anonymous,

 

See if you can access this Google Drive documents: https://drive.google.com/open?id=0B-bZzUsHzLUnZ3ZUY05PQ1gwVmM

 

I made an edit to the queries, made a mistake where it's not getting the total minutes or hours and only extracting the minutes or hours part of the overall duration. Look at page 2 of the PBIX file and see if it's what you are looking for. 

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hello wonga

 

I apologise for the late reply.

 

The file you sent me seems to be it.

 

Thank you very much for yout time and help.

 

Kind regards,

Joaquim