Hi I want to convert 1530 into 15:30. Could anyone tell me the formula to do it. Thanks, Orquidea
O orquidea Nov 15, 2007 #1 Hi I want to convert 1530 into 15:30. Could anyone tell me the formula to do it. Thanks, Orquidea
P Peo Sjoblom Nov 15, 2007 #2 With 1500 in A1 =--TEXT(A1,"00\:00") now don't forget to format the cell with the formula as hh:mm or else you will get a decimal value (for 1500 it would be 0.625) -- Regards, Peo Sjoblom
With 1500 in A1 =--TEXT(A1,"00\:00") now don't forget to format the cell with the formula as hh:mm or else you will get a decimal value (for 1500 it would be 0.625) -- Regards, Peo Sjoblom
