0

Field Duration time in second

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

 

Thank you

 

Mauro

2 replies

null
    • Garden Più
    • Mauro_Schiappelli
    • 3 yrs ago
    • Reported - view

    I entered this formula, I expect a value of 60 minutes but I get 0 zero! 

    number(timestamp(format(Durata, "m")))
    • Ninox developper
    • Jacques_TUR
    • 3 yrs ago
    • Reported - view

    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

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 109Views
  • 2 Following