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 day, so i have a total time for the parts.
I then intend to divide these numbers into the "Day working mins" value so i can get the percent that the machine is being used during working hours.
Thanks in advance.
Anonymous ,
You may try the custom column below.
Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60
5 Replies
Anonymous Add another column for minutes and then use that in the visual
TimeInMinutes = MINUTE( Table[TimeItTookToCreateThePart)
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>])
