to add up hours
 

i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45

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

to add up hours
 

Just add them and format the result Custom as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ceci" wrote in message ...
|i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45