Excel Help!

First of all, sorry in advance if this thread is out of place.


Ok, I am making a Excel spreadsheet on my MP3's I have on my hard drive. All was going well until i came accross this little problem.

Below is a part of my spreadsheet:

URL

Formulas
B9: =COUNTA(B2:B8)
C9: =SUM(C2:C8)*60
D9: =SUM(D2:D8)
E9: =SUM(E2:E8)
G9: =(C9+D9)/60
H9: =E9&" "&F9

(Note: Rows C,D,E,F are going to be hidden in the final product.

Also the Minutes and Seconds rows are only there so i can type in the times quicker without having to type ":" in every row.)


As you can tell, the numbers look alright, but when i compare it to the list on Windows Media Player, it gets ugly.

Excel's Length: 27:55
WMP's Length: 27.36

Excel's Size: 25.22MB
WMP's Size: 25.25MB

I had a complete check to see if i input the wrong details, but it's correct to every detail. What have i done wrong?


Also, if I need to input a number like 4:07 (4 in column C and 07 in column D), it takes the 0 away and in Column G it would come up with 4:7. How can i make it so the 0 stays there?



Thanks in advance

Excel can make little rounding changes and such when you add things, esp when you are adding the results of other operations done in excel. Double check the sizes you entered in the spreadsheet with a calculator, and see if they come out the same as wmp.
To format the cell to keep your :07, you can make custom format cell, with type "00", or a text format cell. Either will keep your 07
HTH

Try the following:

G2: =time(0,c2,d2)
copy this formula down to G8

G9: =sum(g2:g8)

format G9 as time 00:00:00

should give you the right result.

You sir/maddam are a freaking genious!

Thanks