I organise a series of athletics races for my running club and use Excel 2003 to record the finishing times of the competitors.
Times are always under one hour, but I have yet to find a way to record this in Excel without having to use the format hh:mm:ss, ie I must input a zero for the hour every time. If I use mm:ss, I get the wrong figures in the cell. For example, a time of 25 mins 20 secs shows as 20:00. I can continue to use the hh:mm:ss formula, but, with 100 runners details to record, it causes delay.
Also, if I may throw in one additional question, is there a way to use an alternative separator to the colon which requires use of the shift key and yet more typing? If I could use either a full stop of forward slash, I could input the data via the numeric keypad.