Time to Second Sum Aggregation

Reply
Highlighted
White Belt

Time to Second Sum Aggregation

I am having an issue with summing 4 different time to second functions. I have 4 different souces of time in the format of HH:MM : SS which were imported in as text and thus converted to seconds and then minutes. I'm unsure why they cannot sum as they should come out as whole numbers of minutes and when used seperately, they come out as a number. Why am I unable to sum them? 

 

Beastmode function is below: 

SUM((TIME_TO_SEC(`Time1`) / 60),(TIME_TO_SEC(`Time2`) / 60),(TIME_TO_SEC(`Time3`) / 60),(TIME_TO_SEC(`Time4`) / 60))


Accepted Solutions
Major Blue Belt

Re: Time to Second Sum Aggregation

Hi Giolaj,

 

I am not getting into the logical part of the solution, just trying to suggest a syntax here, Please try doing this,
SUM(TIME_TO_SEC(`Time1`) / 60) +
SUM(TIME_TO_SEC(`Time2`) / 60) +
SUM(TIME_TO_SEC(`Time3`) / 60) +
SUM(TIME_TO_SEC(`Time4`) / 60)

 

Hope this helps

 

Regards

Aditya Jain 

'Happy to Help'

View solution in original post


All Replies
Major Blue Belt

Re: Time to Second Sum Aggregation

Hi Giolaj,

 

I am not getting into the logical part of the solution, just trying to suggest a syntax here, Please try doing this,
SUM(TIME_TO_SEC(`Time1`) / 60) +
SUM(TIME_TO_SEC(`Time2`) / 60) +
SUM(TIME_TO_SEC(`Time3`) / 60) +
SUM(TIME_TO_SEC(`Time4`) / 60)

 

Hope this helps

 

Regards

Aditya Jain 

'Happy to Help'

View solution in original post

White Belt

Re: Time to Second Sum Aggregation

That worked, everything added up correctly! Thank you!!

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!