Can anyone please help before I go completely mad.

I am trying to enter minutes and seconds into a spreadsheet but even
though the cell is formatted as m:ss it still requires the user to type
in 0:01:10 for one minute ten seconds and I want to just type 1:10 for
one minute ten seconds, or just 45 for 45 seconds.

Please help.

Thanks.


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298

You can format the cell(s) as mm:ss. I believe you'll still have to enter
0:45 to get 45 seconds. You won't need to enter 0:00:45.

Come back if you have more questions.

Barb Reinhardt

"burrowsybobs" wrote:


Can anyone please help before I go completely mad.

I am trying to enter minutes and seconds into a spreadsheet but even
though the cell is formatted as m:ss it still requires the user to type
in 0:01:10 for one minute ten seconds and I want to just type 1:10 for
one minute ten seconds, or just 45 for 45 seconds.

Please help.

Thanks.


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298

On Wed, 15 Jun 2005 07:01:43 -0500, burrowsybobs
wrote:


Can anyone please help before I go completely mad.

I am trying to enter minutes and seconds into a spreadsheet but even
though the cell is formatted as m:ss it still requires the user to type
in 0:01:10 for one minute ten seconds and I want to just type 1:10 for
one minute ten seconds, or just 45 for 45 seconds.

Please help.

Thanks.

Most likely you will need a VB solution, or a formula in an adjacent column.

Given the above, I assume you will never be typing in hours.

How do you want to differentiate 45 minutes, from 45 seconds?


--ron

Thanks Ron, I would like it to appear as 45.0 if it is minutes and 0.45
if it is seconds.

Regards, Julie


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298

No that doesn't work unfortunately as that is what I thought would work
originally and had already formatted the cells to mm:ss. If I type
0:45, it displays 0:45 in the cell, but actually accepts that as 45
minutes and appears as 00:45:00 in the formula bar. If I type 1:10 it
accepts that as one hour and ten mins (01:10:00 in formula bar), but
displays it as 10:00 which in my spreadsheet would look like 10
minutes.

Regards, Julie


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298

On Thu, 16 Jun 2005 04:00:20 -0500, burrowsybobs
wrote:


No that doesn't work unfortunately as that is what I thought would work
originally and had already formatted the cells to mm:ss. If I type
0:45, it displays 0:45 in the cell, but actually accepts that as 45
minutes and appears as 00:45:00 in the formula bar. If I type 1:10 it
accepts that as one hour and ten mins (01:10:00 in formula bar), but
displays it as 10:00 which in my spreadsheet would look like 10
minutes.

Regards, Julie


Now you've got me confused. So far you have written the following
specifications:

----------------------
I want to just type 1:10 for one minute ten seconds, or just 45 for 45 seconds.

I would like it to appear as 45.0 if it is minutes and 0.45
if it is seconds.
-----------------------


1. FORGET about how the cell is formatted for now. The cell formatting ONLY
affects how Excel *DISPLAYS* the data in the cell. Cell formatting has *NO*
affect on how Excel interprets what you type into that cell.

2. How input is parsed is determined by your Regional Settings (Windows
Control Panel for a Windows machine).

3. Time is stored as fractions of a day.

4. In entering data, what do you want to type in to represent:

forty five seconds
forty five minutes
forty five minutes and forty five seconds
four hours
four hours forty five minutes forty five seconds

5. How do you want to display the above data?



--ron

4. In entering data, what do you want to type in to represent:

forty five seconds
.45

forty five minutes
45

forty five minutes and forty five seconds
45.45

four hours
four hours forty five minutes forty five seconds
nothing will be in hours


5. How do you want to display the above data?

forty five seconds
0.45

forty five minutes
45

forty five minutes and forty five seconds
45.45

Hopefully that all makes some sense.

Regards, Julie


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298