convert decimal figure to minutes and seconds

  • Thread starter Thread starter stevendavina
  • Start date Start date
S

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
 
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).
 
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.
 
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.
Click to expand...
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???
 
Back
Top