Hi,
I'm new to these boards and am hoping you can help me. I've set up a workbook in which my husband can track/analyze pace (minutes/seconds per mile) for the cross country team he coaches. The problem is that I can't figure out how to get the cells to format to show the elapsed time (e.g. 7 minutes 32 seconds). I keep getting time (e.g. 7:32 pm) accompanied by a date. I've tried all different formats - nothing seems to work. Is there a way to enter elapsed time without the hours, the "am/pm" and the date? My fall-back plan is to convert seconds into the equivalent fraction of a minute, and use decimals - but that's a lot of calculation.
Any help would be greatly appreciated.
Thanks.
I'm new to these boards and am hoping you can help me. I've set up a workbook in which my husband can track/analyze pace (minutes/seconds per mile) for the cross country team he coaches. The problem is that I can't figure out how to get the cells to format to show the elapsed time (e.g. 7 minutes 32 seconds). I keep getting time (e.g. 7:32 pm) accompanied by a date. I've tried all different formats - nothing seems to work. Is there a way to enter elapsed time without the hours, the "am/pm" and the date? My fall-back plan is to convert seconds into the equivalent fraction of a minute, and use decimals - but that's a lot of calculation.
Any help would be greatly appreciated.
Thanks.