0

Field Duration time in second

How is the formula to get time in minutes from the duration field type?

 

Thank you

 

Mauro

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I entered this formula, I expect a value of 60 minutes but I get 0 zero!

    number(timestamp(format(Durata, "m")))
    Like
  • Duration fields return a value in milliseconds.  To get the value of a duration field in seconds, simply divide it by 1000:

     number(Durata)/1000

    Like
Like Follow
  • 6 mths agoLast active
  • 2Replies
  • 34Views
  • 2 Following