If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)

If you mean in the formula bar then you need to change your regional setting
in the control panel to 24 hours (HH:mm)
if you meant in the cell itself just use hh:mm or [hh]:mm as format

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)

Sorry, I didn't explain that correctly . . .
I have a recording which is 1 minute and 30 seconds that I want to display
as 1:30 (minutes and seconds) or if I have a 1 minute recording and I enter 1
I would need it to display 1:00.

Elsewhere I want to display the amount in seconds only. so in the example
above there would be
90
60

"Peo Sjoblom" wrote:

If you mean in the formula bar then you need to change your regional setting
in the control panel to 24 hours (HH:mm)
if you meant in the cell itself just use hh:mm or [hh]:mm as format

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)

To convert 1 to 1:00 in minutes and seconds upon entering it you need to
either use an event macro
or an extra cell with a formula. To convert 90 (seconds) entered in one cell
to 1:30
in another you can use


=A1/86400

and format as mm:ss

where A1 holds 90

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
Sorry, I didn't explain that correctly . . .
I have a recording which is 1 minute and 30 seconds that I want to display
as 1:30 (minutes and seconds) or if I have a 1 minute recording and I
enter 1
I would need it to display 1:00.

Elsewhere I want to display the amount in seconds only. so in the example
above there would be
90
60

"Peo Sjoblom" wrote:

If you mean in the formula bar then you need to change your regional
setting
in the control panel to 24 hours (HH:mm)
if you meant in the cell itself just use hh:mm or [hh]:mm as format

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and
30
minutes)

To have an entry of 1:30 displayed as such, use a format of h:mm.

However, Excel will assume this is hours and minutes, not minutes and
seconds. If you're not doing any calculations with it, it won't matter. If
you are, there are several workarounds. Post back if you need any.

Regards,
Fred.

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)

Here is what I ended up with
TEXT(A1/60,"[ss]")

When A1 holds 1:00 it returns 60
When A1 holds 1:30 it returns 90
When A1 holds 0:30 it returns 30

Thanks for the help

"Peo Sjoblom" wrote:

To convert 1 to 1:00 in minutes and seconds upon entering it you need to
either use an event macro
or an extra cell with a formula. To convert 90 (seconds) entered in one cell
to 1:30
in another you can use


=A1/86400

and format as mm:ss

where A1 holds 90

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
Sorry, I didn't explain that correctly . . .
I have a recording which is 1 minute and 30 seconds that I want to display
as 1:30 (minutes and seconds) or if I have a 1 minute recording and I
enter 1
I would need it to display 1:00.

Elsewhere I want to display the amount in seconds only. so in the example
above there would be
90
60

"Peo Sjoblom" wrote:

If you mean in the formula bar then you need to change your regional
setting
in the control panel to 24 hours (HH:mm)
if you meant in the cell itself just use hh:mm or [hh]:mm as format

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and
30
minutes)

As you don't want to do any calculations with this number, you can get the
same results, and avoid an intermediary cell, by using a format of [mm]

Regards,
Fred.

"TitanG" wrote in message
...
Here is what I ended up with
TEXT(A1/60,"[ss]")

When A1 holds 1:00 it returns 60
When A1 holds 1:30 it returns 90
When A1 holds 0:30 it returns 30

Thanks for the help

"Peo Sjoblom" wrote:

To convert 1 to 1:00 in minutes and seconds upon entering it you need to
either use an event macro
or an extra cell with a formula. To convert 90 (seconds) entered in one
cell
to 1:30
in another you can use


=A1/86400

and format as mm:ss

where A1 holds 90

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
Sorry, I didn't explain that correctly . . .
I have a recording which is 1 minute and 30 seconds that I want to
display
as 1:30 (minutes and seconds) or if I have a 1 minute recording and I
enter 1
I would need it to display 1:00.

Elsewhere I want to display the amount in seconds only. so in the
example
above there would be
90
60

"Peo Sjoblom" wrote:

If you mean in the formula bar then you need to change your regional
setting
in the control panel to 24 hours (HH:mm)
if you meant in the cell itself just use hh:mm or [hh]:mm as format

--


Regards,


Peo Sjoblom

"TitanG" wrote in message
...
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour
and
30
minutes)