Adding durations
 

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

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
|
|

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
|
|

Adding durations
 

Select one of the duration cells and Format | Cells | Number (tab) -
you will probably find that the cells are formatted as text. You could
add a formula in a helper column such as:

=VALUE(D2)

assuming D2 is the first duration cell, then copy down. You should then
be able to sum on this column. You could fix the values and copy over
the original data, if you want to retain the same layout that you have
now.

Hope this helps.

Pete

B Bear wrote:
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
|
|

Adding durations
 

Think I just tried that??
And still 00:00
I'm formatting the cells to custom 00:00:00 then in the total box making
sure that is the same format.
Sigma on the total cell which then seems to want a range of cells put in.
Click the top cell and highlight down to the lowest puts the range in.
Enter and 0's.
:-(



"Pete_UK" wrote in message
ups.com...
Select one of the duration cells and Format | Cells | Number (tab) -
you will probably find that the cells are formatted as text. You could
add a formula in a helper column such as:

=VALUE(D2)

assuming D2 is the first duration cell, then copy down. You should then
be able to sum on this column. You could fix the values and copy over
the original data, if you want to retain the same layout that you have
now.

Hope this helps.

Pete

B Bear wrote:
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
|
|