Excel 97 - adding a column of hours

  • Thread starter Thread starter Yvonne
  • Start date Start date
Y

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