View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
B Bear B Bear is offline
external usenet poster
 
Posts: 12
Default Adding durations

Tried that. No go. Get formula error type message or 00:00:00.
Probably me!

"Niek Otten" wrote in message
...
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
|
|