Forum Discussion

Pmorg73's avatar
Pmorg73
Post Patron
6 years ago
Solved

Time format export data from hours to decimal

  I have an interesting query   I am working in time and invoice management web site called workflow max. To get data from the web site I export reports in csv format. For small time entrie...
Need Help
  • Pmorg73's avatar
    Pmorg73
    6 years ago

    In query editor. Select the column and split it by deliminator

    You get two columns. 1 is hours, 1 is mins

    New column = hours + (mins/60) = decimal number and works with values over 24 hours. 

     

    KISS

Pmorg73's avatar
Pmorg73
Post Patron
6 years ago

now I am compleley lost......

 

where do I put ?  I see nowehere to do this

 

Duration.TotalHours( Duration.From( [Time Column] ) )

 

Pmorg73's avatar
Pmorg73
Post Patron
6 years ago

last one for a Sunday. Its time to stop haha

 

two images attached. I interogated the csv file for one specific case. Where ever my entry is greater than 24 hours it is completely and utterly wrong. In query editor I changed the format to duration. That is all I did as I dont follow your other comments and how to apply the DAX line you stated. (???)