Has anyone created an Excel template for tracking times?
Parents
Former Member
I would love to have one. I can't figure out how to get Excel not to convert time times into "time" (i.e. time of day). Actually if I just knew how to do that, then I'd be set.
If you are putting your times in a column, say, then you highlight that column and then click Format, click Cells and, finally, highlight Text in the new window that opens and click OK to implement the change in format. That will force the entries to take what you type in, so 10:45.47 should appear as just that instead of defaulting to time of day. It will probably automatically left justify so, if this annoys you, you can change the justification in the column.
This works with my version of Excel which is from MS Office 2000. I have both a daily training log and long-term record of all my master's swims in Excel and haven't had any problem.
I would love to have one. I can't figure out how to get Excel not to convert time times into "time" (i.e. time of day). Actually if I just knew how to do that, then I'd be set.
If you are putting your times in a column, say, then you highlight that column and then click Format, click Cells and, finally, highlight Text in the new window that opens and click OK to implement the change in format. That will force the entries to take what you type in, so 10:45.47 should appear as just that instead of defaulting to time of day. It will probably automatically left justify so, if this annoys you, you can change the justification in the column.
This works with my version of Excel which is from MS Office 2000. I have both a daily training log and long-term record of all my master's swims in Excel and haven't had any problem.