convert excel decimal total to minutes and seconds

[steve h]

Hello

I have listed a total amount of timings for a study that I have totalled giving me a figure of 34.76 which is under an hour.

how do i convert to min and seconds - is there a formula??

HELP!!!!!!!!!

 

[Kap]

You could always take all your values and use the "text to columns" function under the Data menu. Just delimit with a period. Then you'll have one column for the minutes and one for the seconds and you can do this:

......A....B
1....1....25
2....1....25
3....1....25
4....1....25


=TIME(0,SUM(A1:A4),SUM(B1:B4))

 

[wyco]

maybe useful for someone in the future.
try: =FLOOR(D20,1)&":"&TEXT((D20-FLOOR(D20,1))*60,"00")

 

[Scott Huish]

This will do it as well:
=DOLLARDE(D20,60)/24

Format as [h]:mm

Note, if you are using a version of Excel prior to XL2007, you will need to load the Analysis Toolpak for this.