Forum Discussion
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...
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
playing further in query editor
I made it a duration as discussed. I just went to transform and clicked on make sum of hours.......returns a decimal value of each row that at first glance looks correct......this might be my solution. will just interogate
no its incorrect values. not the solution. 109hours output turned in to 13.3 hours so its miles off