I have a column of numbers that I’d like to display as HH:MM:SS format. Any idea on how to do this in Monday? I understand this would be a bit easier in a table program but I just can’t figure at this moment. If anybody knows how to do this or has done it before that would be greatly appreciated if you could explain.
Where will the numbers be coming from? Is it related to time tracking as we do have a time tracking column to help with that.
Let me know!
I didn’t realize how old this post was until I had put this together. I’m assuming that you have already figured this out. But, since we’re here…
One way to convert pure seconds to HH:MM:SS format:
TEXT(ROUNDDOWN({Seconds}/3600,0),"#0") & ":" & TEXT(ROUNDDOWN(MOD({Seconds},3600)/60,0),"00") & ":" & TEXT(MOD({Seconds},60),"00")
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.