T
TitanG
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)
minutes)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
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
T
TitanG
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
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 said: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 said:If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and 30
minutes)
P
Peo Sjoblom
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
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 said: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 said: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 said:If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and
30
minutes)
F
Fred Smith
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.
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.
T
TitanG
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
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 said: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 said: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 said: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
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour and
30
minutes)
F
Fred Smith
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.
same results, and avoid an intermediary cell, by using a format of [mm]
Regards,
Fred.
TitanG said: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 said: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 said: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
:
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
If I enter in 1:30 I want it to display 1:30 not 1:30 AM. (1 hour
and
30
minutes)