Entering Time Data
I need to enter a whole lot of hand written time data into a spreadsheet. The data is in the format hh:mm:ss, (i.e. 03:21:32, 11:23:32, 18:11:22, …)
I am working on a laptop and I am looking for ways to reduce key strokes, is there a way to format a cell to automatically enter the colon “:”? I just want to type 032132 and have excel convert this to 03:21:32.
Any ideas would be helpful.
Thanks
tball
I need to enter a whole lot of hand written time data into a spreadsheet. The data is in the format hh:mm:ss, (i.e. 03:21:32, 11:23:32, 18:11:22, …)
I am working on a laptop and I am looking for ways to reduce key strokes, is there a way to format a cell to automatically enter the colon “:”? I just want to type 032132 and have excel convert this to 03:21:32.
Any ideas would be helpful.
Thanks
tball