0

Sum timestamp

I need to sum the total duration of more than one timestamp for a specific user, however it doesn't allow the sum function.

 

I don't want to convert it to hours or minutes, as I need it to show as total duration (HH:mm:ss) same as excel when choosing time formula type 37:30:55

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • HH:mm:ss

    floor(timeBetween(End Time,Start Time)/1000/60/60):

    floor(timeBetween(End Time, Start Time)/1000/60)-floor(timeBetween(End Time, Start Time)/1000/60/60)*60: 

    timeBetween(End Time, Start Time)/1000 -floor(timeBetween(End Time, Start Time)/1000/60)*60

    Like 1
  • I need to sum the total duration of more than one timestamp for a specific user, however it doesn't allow the sum function.

    I have Hours and mins and Secons in Integer format so i need to convert these into total duration(HH:MM:SS).

    Like
Like Follow
  • 4 mths agoLast active
  • 2Replies
  • 83Views
  • 3 Following

Product Announcement

Incorta 5 is now Generally Available