Formula for turning a decimal into HH:MM:SS format

Platform discussions Special workflows & use cases
1

I have a formula set up to add together several time tracking columns.

That formula looks like this:

DIVIDE(SUM({Monday#Minutes}, {Tuesday#Minutes}, {Wednesday#Minutes}, {Thursday#Minutes}, {Friday#Minutes}, {Saturday#Minutes}, {Sunday#Minutes} ),60)

That gives me an answer as a decimal. How do I get that into HH:MM:SS format?

2

Hi Brittni,

To convert a {Numbers} column representing hours to HH:MM, use:

CONCATENATE(INT({Numbers}/60),":",TEXT(MOD({Numbers},60),"00"))

To convert a {Numbers} column representing hours to HH:MM:SS, use:

CONCATENATE(INT({Numbers}/60),":", TEXT(INT(MOD({Numbers}, 60)), "00"),":",TEXT(ROUND(MOD({Numbers}*60, 60), 0),"00"))

“Simply” replace all the occurrences of {Numbers} by your current formula.

 
 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.