EXCEL QUESTION

[Dread7994]

WIN 2000
OFFICE 2000
I NEED A FORMULA FOR EXCEL THAT CONVERTS SECS INTO MINUTES EXAMPLE (145 SEC = 2MINS 25 SECS (i.e. 2:25). I WANT IT TO READ IN THIS FORM (2:25).

THANK YOU IN ADVANCE.

SHAUN

 

[ETID]

if 145 is in cell A1

then formula in b1 is.....


=INT(A1/60)&":"&MOD(A1,60)

 

[sfvb]

If cell A1 contained 125, you would get 2:5
If you wanted it to be 2:05 instead, then just alter ETID's formula to this:

=INT(A1/60)&":"&RIGHT(MOD(A1,60)+100,2)

 

[KenWright]

Just to give you another option, you could just format the cell as:-

([mm]:ss)

and then enter the data as 00:00:145

which will show as (02:25)

or ([m]:ss)

which will show as (2:25)

Regards
Ken..............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[IsThisOneTaken2]

=A1/1440

The destination cell should be formatted like this:
h:mm

 

[xlbo]

Use "IsThisOneTaken2"'s suggestion but format as mm:ss for your mins and secs...

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[sfvb]

If you do as xlbo said then you'll need to divide by 86400 not 1440

 

[xlbo]

good spot sfvb - for the record
To convert from seconds, /86400
To convert from minutes, /1440
To convert from hours, /24

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244