Excel 97 - adding a column of hours

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
 
C

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 .
 
W

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:
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.
 
Top