Forum Discussion
sliao8788
Mar 06, 2021Copper Contributor
convert numbers to time
Hi I am trying to convert a number format in one cell to time format in another cell. Here is my example In cell A1 I have a number 1.90 and I need it to be converted into 1:90 in cell B1. what for...
SergeiBaklan
Mar 06, 2021Diamond Contributor
What 1:90 shall practically mean, 1hour 90 minutes? Or you mean 1.9/24 = 01:54:00 ?
- sliao8788Mar 06, 2021Copper Contributor
SergeiBaklan yes it should show 1hour 90 minutes