to add up hours
Just use the SUM function:
=SUM(A1:A3)
Format the cell as [h]:mm
The [ ] keep the hours from rolling over after 24.
For example, without using the [h]:mm format the result of the SUM formula
would be 0:45.
Biff
"ceci" wrote in message
...
i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45
|