Forum Discussion
Total amount per day
I have a table that contains the columns; Date TimeItTookToCreateThePart My form currently is counting the amount of entries per day. Is it possible to add all the time up for each d...
Anonymous ,
You may try the custom column below.
Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60
Hi Parry,
The option you have suggested only takes the minutes out of the data.
eg If the data was 01:01:30 it would only be viewed as 1 Minute
Is it possible to convert data eg hh:mm:ss 01:01:30 into 61.5 minutes ?
Regards
Anonymous may be it is easier to add new column in power query using duration formula, add new custom column in power query and use following
https://docs.microsoft.com/en-us/powerquery-m/duration-totalminutes
Duration.TotalMinutes([<Your column name>])
Perry, I am unable to convert to Duration (See attached image)
Any other suggestions?
I appreciate the help so far.
Regards,
Anonymous ,
You may try the custom column below.
Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60