Possible Duplicate:
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 1500
to 15:00
.
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.