Minutes and seconds field format

[Earl Kiosterud]

Andrew;

Consider using separate adjacent columns for minutes, and seconds. Then you
can easily calculate the total time wherever needed. Entering the time is
easy, using the tab key between minutes and seconds.

Regards from Virginia Beach, VA

Earl Kiosterud
ea...@livenet.net
-------------------------------------------------------------

Andrew Burrell wrote in message
<7mjdbo$12r$1...@nclient5-gui.server.virgin.net>...
>I want to enter data into fields for a CD collection spreadsheet, and I
want
>to record the track times.
>
>I need to find an appropriate format that can display the data correctly
and
>so I can perform calculations on the data.
>
>For example:
>
>If I want to enter 5 minutes 25 seconds to show as 5:25, the cell shows
>05:25 which is fine, but the cell bar shows 05:25:00. If I go to format the
>cell, the field type is hh:mm (hours, minutes).
>
>If I change this to mm:ss (minutes, seconds) the cell then shows 25:00,
>so I now have to enter times as 0:5:25 to get the cell to show the correct
>data(05:25), and the cell bar now reads 00:05:25.
>
>I want to able to enter the data without haing to preceed it with '0:' each
>time to tell Excel I am entering minutes and seconds, not hours and
minutes.
>
>Is there a work-around or add-in I should be applying? Help!
>
>Office2000 has not improved this either as far as I can tell.
>
>andy
>
>

[Andrew Burrell]

[Andrew Burrell]

Earl,

Remember there are only 60 minutes and 60 seconds so when a simple
calculation of a few values which goes over 59 this idea breaks down, unless
the calculation can have a formula applied to carry "1" for every
"minute"(60 seconds) or "hour"(60 minutes)

Andy

Earl Kiosterud wrote in message ...

>Andrew;
>
>Consider using separate adjacent columns for minutes, and seconds. Then you
>can easily calculate the total time wherever needed. Entering the time is
>easy, using the tab key between minutes and seconds.
>
>Regards from Virginia Beach, VA
>
>Earl Kiosterud
>ea...@livenet.net
>-------------------------------------------------------------
>
>
>
>Andrew Burrell wrote in message
><7mjdbo$12r$1...@nclient5-gui.server.virgin.net>...