convert decimal to hour and minute

AppSheet AppSheet Q&A
,
1

Hey, guys.

I have two columns.

In the first column I insert a decimal number

and I want the second column to automatically convert this decimal value to hour and minute.

Example: Column 1 Enter 4.88.

I want me to return 4:53

ECardoso_1-1697508788982.png
ECardoso_1-1697508788982.png275×108 2.88 KB

Any tips?

2

You can try

FLOOR([col]) & 
":" & 
RIGHT(FLOOR((([col] - FLOOR([col])) * 60)) + 100, 2)