convert decimal figure to minutes and seconds

[stevendavina]

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

 

[David Biddulph]

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).

 

[Gaurav]

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.

 

[stevendavina]

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.

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???