Forum Discussion
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...
Try changing the number format to: [h]:mm
JMB17 Thanks for the response. When I tried it with your formula, it didn't work even with changing the format to [H]:mm, but when I tried it with the formula Riny_van_Eekelen suggested, it worked.
Sincere thanks to JMB17 Riny_van_Eekelen and NikolinoDE for all your help. Appreciate it.