Excel 97 - adding a column of hours

[Yvonne]

Hi, I have a user who wants to add a column of hours,
i.e. 1:30, 7:25, 2:30 - the total should be 11:25 hours.
How do get this function to work in Excel 97?

Thanks
Yvonne

 

[Chip Pearson]

Yvonne,

You can simply add the numbers with a formula like =SUM(A1:A4) or
=A1+A2+A3+A4. Use a custom number format of [hh]:mm or [hh]:mm:ss .

 

[Wayne]

-----Original Message-----
Hi, I have a user who wants to add a column of hours,
i.e. 1:30, 7:25, 2:30 - the total should be 11:25 hours.
How do get this function to work in Excel 97?

Thanks
Yvonne
.
Hi, you need to format each cell as follows:

1. Highlight the cells to format
2. Open drop down window FORMAT
3. Go to CELLS and click
4. Go to the NUMBER tab
5. Highlight category TIME
6. Highlight the Type of preference, e.g 13:30.

This should add times correctly when you do the sum
function.