Convert seconds to time format

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.

Hi @kevinmarchese

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!

@kevinmarchese,

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.