Convert Excel Text string to Time
I must enter appointment times in a workbook.
For instance I have cell
E2 to input the time. I'll input, lets say
1500. How can I change
I have tried several
=TIMEVALUE() statements I have found but when I put in the string
1500 or similar, the result that appears in the cell is
0:00 and the formula bar shows current date and time.