Time entered (and handled as data) in simple minutes and seconds.
- From: "MDriggers" <mdriggers@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Feb 2007 17:02:52 -0500
Using Excel 2003.
How can I get Excel to display and handle entries for duration in minutes
and seconds only (without having to enter a 4'30" entry as 0:04:30)? I have
gotten as far as getting it to display as "04:30.0", but all I need is
single digit minutes (data on this spread*** will never go over 9:59) and
double digit seconds (and to be able to enter them simply as in "4:30"). I
couldn't find that as an option in the ones listed for time in the cell
format dialogue box. Right now I have to enter 0:04:30 in order to get it
to work right. Is there a simpler option?
Thanks.
.
- Follow-Ups:
- Re: Time entered (and handled as data) in simple minutes and seconds.
- From: Dave Peterson
- Re: Time entered (and handled as data) in simple minutes and seconds.
- Prev by Date: Re: How can I remove hidden apostrophe in Excel?
- Next by Date: Re: using environment variable in macro path
- Previous by thread: broken axis bar graph
- Next by thread: Re: Time entered (and handled as data) in simple minutes and seconds.
- Index(es):