Need a small help with Excel

[antipop]

I need for my project to do a an excel file where i write every week how much my mates and i worked on the project
I added a column for the total per week and one for the grand total for each of us. The problem is that i don't really know to use excel and i need to enter the number of hours, is there a way to make the soft automatically add the time and correctly add the hours and minutes?

[Teus]

let's say the time of you is in A1, A2, A3, A4,....A10

and the cell that counts all work in hours and in minutes is B1

B1= sum(A1:A10)

right click the A1-A10 AND B1, cell properties, then go to "Time". select the time notation you want

[antipop]

10x it's working but i have to type this for every column right?

[faruquehabib]

Originally posted by antipop
10x it's working but i have to type this for every column right?

i think you can highlight and drag, and it will copy it over to other columns...depends on which version of excel you are using (office 98, office xp, office 2003, etc.)

[apathy^2]

any idiots guides to excel?