Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may try the custom column below.

    Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Perry, I am unable to convert to Duration (See attached image)

Any other suggestions?

I appreciate the help so far.

 

Regards,

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous ,

 

You may try the custom column below.

Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60