How do I get Excel to read 13:48 as 13 minutes and 48 seconds of just plain old elapsed time (so I can use it in a calculation)? NOT 1:48 PM...NOT 1/1/1900 00:13:48.... etc, etc.

Very, very frustrating!

I'm using Excel '97.

BTW, OpenOffice Spreadsheet has the same problem.