Convert number to Hours & Minutes

Question

I am trying to convert numbers to hours, i have looked at all solutions in community but nothing seems to be working. I have used ToDateTime([Time])/1440

but its giving me error as Error: Type mismatch in operator +.

I have made sure to use Select tool and clean the datatype as Double.

Can someone pls help with simple solution, incase of bigger formula pls help with explanation.

Thanks you

SPetrie · Answer

In what way is it not working? Can you share a screenshot or the error message?

Are they coded as numbers or a string?

When I try 7.139456 in the formula I get 7:08 as the result.

Diemm · Answer

You can use the formula that the previous guy give you, but add a formula before to limite the number of decimals (like round) to make the datetime formula works.

Sahil7 · Answer

Thanks for this, but there are certain cells that has number with 6 decimals. for ex 7.139456. its not working on those cell, any refining?