# Display decimal as time without TEXT()

Hi all,

I’m currently using a formula column which is

`TEXT(sum({Lauren Time Tracking},{Letters Lauren}), "hh:mm")`
Output = 47:06:11

and it works perfectly - except I’m now trying to use that output and I’ve been told it wont be able to use TEXT()

so when I remove text it now outputs in seconds -

E.G. 169,571 so I then add in a /3600 which makes it 47.103 (decimal time) but I need it to show the minutes and seconds rather than decimal

Any ideas how I do that?

I managed to find this:

Function
TEXT()

Example
TEXT({Amount},“\$#,##0.00”)

Workaround
ROUND(100*({Amount}),0)/100

But I can’t see how I can use this?

@JCorrell

Hey Jim,
You helped me out a while back with
`RIGHT("0" & INT({Hours}), 2) &"h "& RIGHT("0" & ROUNDUP(MOD({Hours},1) * 60, 0), 2) & "m"`
so I’ve tried to use this, but I need to be adding 2 columns together to get this to work - Any ideas on how to integrate

`sum({Lauren Time Tracking},{Letters Lauren})`
I did try
`RIGHT("0" & INT(sum({Lauren Time Tracking},{Letters Lauren})), 2) &"h "& RIGHT("0" & ROUNDUP(MOD(sum({Lauren Time Tracking},{Letters Lauren}),1) * 60, 0), 2) & "m"`

but its not showing the right info

Its displaying

71h 00m not 47h 06m

@johnners

You will need to adjust the formula to work with HOURS instead of seconds. Try this:

``````RIGHT("0" & INT(SUM({Lauren Time Tracking}, {Letters Lauren}) / 3600), 2) & "h " & RIGHT("0" & ROUNDUP(MOD(SUM({Lauren Time Tracking}, {Letters Lauren}) / 3600, 1) * 60, 0), 2) & "m"
``````

Jim - The Monday Man
Do you wish there was an app that.… Visit the Wishing Well and make your wish come true!
Update Magic #1 New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

Amazing, thank you so much!!

1 Like