hi i need a formula to convert

e.g 1 min 78 seconds to minutes and seconds in usual format e.g 2 min
18 seconds

I have a list of times all in minutes and seconds that when totalled
are tottaled in a decimal way i then need to change in minutes and
seconds

If you have minutes in A1 and seconds in B1, use =TIME(0,A1,B1) and format
as time [m]:ss

Check that your totals of minutes and of seconds are within the limits
specified for the TIME function. If they are not, you can use
=A1/(24*60)+B1/(24*3600).
--
David Biddulph

wrote in message
...
hi i need a formula to convert

e.g 1 min 78 seconds to minutes and seconds in usual format e.g 2 min
18 seconds

I have a list of times all in minutes and seconds that when totalled
are tottaled in a decimal way i then need to change in minutes and
seconds

If its 1.78 and if you convert it to Time format, it will be 1:46.

Try it with 1.78 in A1 enter the following in B1

=A1/24

Format B1 as Time.


wrote in message
...
hi i need a formula to convert

e.g 1 min 78 seconds to minutes and seconds in usual format e.g 2 min
18 seconds

I have a list of times all in minutes and seconds that when totalled
are tottaled in a decimal way i then need to change in minutes and
seconds

On May 6, 3:02*pm, "Gaurav"
wrote:
If its 1.78 and if you convert it to Time format, it will be 1:46.

Try it with 1.78 in A1 enter the following in B1

=A1/24

Format B1 as Time.

wrote in message

In this instance when i convert to time in b1 it then converts to 1
hour 46 min and 48 seconds.

The 1.78 is 1 minute and 78 seconds???