Convert Number (Double) to Time Format

Hi all,

I have a column that contains whole numbers where there should be time. The number I have is the amunt of hours. For example I have 91.97 where it should be 91:59:00, 90.14 where it should be 90:08:00. I tried the time formatting tools and they didn't work. Do you know how I can do that change?

Thanks!

Date Time

Preparation

Accepted answers

grossal

I read your last part a bit to late and already got a way without rounding or using Fixed Decimal.

Let me note this: The datatype "time" won't work because the data type is only made for day "times" (up to 24h - or at least that's what I am aware off).

Workflow attached. Let me know what you think.

Best

Alex

2020-04-30-time conversion.yxmd

All comments

grossal

Hi @Patricia2,

We could use a Formula to do the trick, but your precision isn't good enough.

.96 * 60 = 58.2 (Goal: 59)

.14 * 60 = 8.4 (Goal 😎

We could round, but no matter if we always round up or down, we won't get both to work. How should we handle it?

Best

Alex

Patricia2

Well the actual number contains more decimals than the example I gave. The number actually is

91.97833

and I want it to be

91:58:42

When I apply those operators it multiplies also the number of decimals so I can't get a number with just hours, minutes (2 digits) and seconds (2 digits). is there a tool to remove the remaining decimals?

thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703