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)