Display decimal as time without TEXT()

Platform discussions Special workflows & use cases
1

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?

2

@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

3

@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!
:magic_wand: Update Magic #1 – New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

4

Amazing, thank you so much!!

1 Like