Tip Printed from ExcelTip.com

---

Converting a Number to a Time Value


To quickly type time values into cells:

Enter the following formula:

=IF(A31000,TIMEVALUE(LEFT(A3,1)&":"&RIGHT(A3,2)),TIMEVALUE(LEFT(A3,2)&":"&RIGHT(A3,2)))

The formatting of the cells in column B is HH:MM.