Adding durations
Don't highlight.
Just select a cell under your data and hit the sigma.
You may have to paint the time format into it, or even format it Custom with [h]:mm:ss, to prevent the cell from tipping over at
24h
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"B Bear" wrote in message ...
| Hi
| I'm using excel '97.
| I have a spread sheet with durations on it (vodafone) and want to add them.
| Is there any way to do this?
| When I highlight and hit sigma it tries to enter nothing in the top
| selection instead of the total at the bottom.
| Cheers BB
|
|
|