View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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
|
|