Skip to main content

How to format time in a lookup array of durations?

  • October 21, 2022
  • 0 replies
  • 3 views

Ricardo11
Forum|alt.badge.img+16

Hey there, I’m looking up a duration formatted formula field from multiple records. The result of the lookup looks like this ā€œ4:24, 6:00, 6:31ā€.

Is there a way to reference and DATETIME_FORMAT this in a formula field and get a similar output format? I cannot figure it out and get a zero value or the underlying seconds.