I do not know if this will work for you but give it a try :
Under Format, Cell, click on the Number tab and select Time
When entering minutes and seconds they shoudl read 0:1:40 for 1 minute forty
seconds.

Good luck.


"karriker" wrote:

I am trying to tabulate the time that i have spent working out and the way i
am trying to do it is not working. Excel is entering the the time ie 1 minute
40 seconds as a time 12:01.40 am. so when i try to sum the total time I am
getting a crazy Answer