|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
No luck so far
-----
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.
:-(
-----------------
|
|
Just checking..
you format it to 00:00:00
I hope you actually mean Time or hh:mm:ss in the Custom option
What do you see in the formula bar at the top when you click on one of =
cells in your range?
Re-format that to Time (13:30:55 option)
Does this alter what appears in the cell and on the formula bar ?
[Quoted Text] > Sigma on the total cell which then seems to want a range of cells put =
in.
of course it wants a range - it needs to know what you want to sum.
Usual set up of a worksheet, if you enter a column of numbers/times etc =
=
then in a cell below these (not necessarily next to the bottom one)
Click on the cell, then the Sigma button
You should get =3Dsum(B5:B15) or whatever your range is - and it should =
=
automatically pick up the block of cells above the cell you are in.
if it doesn't do this then it doesn't think the cells are numeric
So back to the formatting again.
Steve
On Sat, 26 Aug 2006 17:54:44 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>=
=
wrote:
> No luck so far
> -----
> Think I just tried that??
> And still 00:00
> I'm formatting the cells to custom 00:00:00 then in the total box maki=
ng
> 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.
> :-(
>
> -----------------
>
>
|
|
Format as Custom - [h]:mm:ss
"B Bear" wrote:
[Quoted Text] > No luck so far
> -----
> 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.
> :-(
>
> -----------------
>
>
>
|
|
No it doesn't change when I go to the 13:30:55 option.
Yes I get sum(****)
BB
"SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
news:op.tewji0xlevjsnp[ at ]enigma03...
Just checking..
you format it to 00:00:00
I hope you actually mean Time or hh:mm:ss in the Custom option
What do you see in the formula bar at the top when you click on one of
cells in your range?
Re-format that to Time (13:30:55 option)
Does this alter what appears in the cell and on the formula bar ?
[Quoted Text] > Sigma on the total cell which then seems to want a range of cells put in.
of course it wants a range - it needs to know what you want to sum.
Usual set up of a worksheet, if you enter a column of numbers/times etc
then in a cell below these (not necessarily next to the bottom one)
Click on the cell, then the Sigma button
You should get =sum(B5:B15) or whatever your range is - and it should
automatically pick up the block of cells above the cell you are in.
if it doesn't do this then it doesn't think the cells are numeric
So back to the formatting again.
Steve
On Sat, 26 Aug 2006 17:54:44 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
wrote:
> No luck so far
> -----
> 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.
> :-(
>
> -----------------
>
>
|
|
Getting annoyed now!!!
Now where's my base 60 calculator?
"B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
[Quoted Text] > No luck so far
> -----
> 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.
> :-(
>
> -----------------
>
>
|
|
No need to get annoyed! If you format as hh:mm:ss, you will be stuck in a 24
hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a total
of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's a
load of difference between formatting as 00:00:00, hh:mm:ss and [h]:mm:ss
"B Bear" wrote:
[Quoted Text] > Getting annoyed now!!!
> Now where's my base 60 calculator?
>
>
> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
> > No luck so far
> > -----
> > 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.
> > :-(
> >
> > -----------------
> >
> >
>
>
>
|
|
Off to try it
"kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
[Quoted Text] > No need to get annoyed! If you format as hh:mm:ss, you will be stuck in a
> 24
> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
> total
> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
> a
> load of difference between formatting as 00:00:00, hh:mm:ss and [h]:mm:ss
>
> "B Bear" wrote:
>
>> Getting annoyed now!!!
>> Now where's my base 60 calculator?
>>
>>
>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>> > No luck so far
>> > -----
>> > 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.
>> > :-(
>> >
>> > -----------------
>> >
>> >
>>
>>
>>
|
|
No. Still comes up with 0's.
When I go back to format it shows it as being in time format even though I
set [h]:mm:ss.
calm calm calm!
"kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
[Quoted Text] > No need to get annoyed! If you format as hh:mm:ss, you will be stuck in a
> 24
> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
> total
> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
> a
> load of difference between formatting as 00:00:00, hh:mm:ss and [h]:mm:ss
>
> "B Bear" wrote:
>
>> Getting annoyed now!!!
>> Now where's my base 60 calculator?
>>
>>
>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>> > No luck so far
>> > -----
>> > 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.
>> > :-(
>> >
>> > -----------------
>> >
>> >
>>
>>
>>
|
|
[h]... is a Time format, just not on it's normal list
Right, back to basics.
Either work on a copy of the worksheet or *don't save* it after these =
changes.
Click on the column with the times and the sum in
Format to general
Remember what these look like
Format the whole column again to Time (13:30:55 option)
Now what do you see in the cells and the sum.
Rememebr the sum may display wrong - we'll deal with that later.
Steve
On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>=
=
wrote:
[Quoted Text] > No. Still comes up with 0's.
> When I go back to format it shows it as being in time format even thou=
gh =
> I
> set [h]:mm:ss.
> calm calm calm!
>
> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck=
=
>> in a
>> 24
>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get=
a
>> total
>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. =
>> There's
>> a
>> load of difference between formatting as 00:00:00, hh:mm:ss and =
>> [h]:mm:ss
>>
>> "B Bear" wrote:
>>
>>> Getting annoyed now!!!
>>> Now where's my base 60 calculator?
>>>
>>>
>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>>> > No luck so far
>>> > -----
>>> > 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.
>>> > :-(
>>> >
|
|
Hi
Off to work so if I'm a bit slow getting back you know why.
Just did that. In general the sum is just 0.
In time the sum is 00:00:00.
The sum box has the range in it
"SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
news:op.tezd6bkrevjsnp[ at ]enigma03...
[h]... is a Time format, just not on it's normal list
Right, back to basics.
Either work on a copy of the worksheet or *don't save* it after these
changes.
Click on the column with the times and the sum in
Format to general
Remember what these look like
Format the whole column again to Time (13:30:55 option)
Now what do you see in the cells and the sum.
Rememebr the sum may display wrong - we'll deal with that later.
Steve
On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
wrote:
[Quoted Text] > No. Still comes up with 0's.
> When I go back to format it shows it as being in time format even though
> I
> set [h]:mm:ss.
> calm calm calm!
>
> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck in
>> a
>> 24
>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
>> total
>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00.
>> There's
>> a
>> load of difference between formatting as 00:00:00, hh:mm:ss and
>> [h]:mm:ss
>>
>> "B Bear" wrote:
>>
>>> Getting annoyed now!!!
>>> Now where's my base 60 calculator?
>>>
>>>
>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>>> > No luck so far
>>> > -----
>>> > 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.
>>> > :-(
>>> >
|
|
Ah! being dim! Just tried it entering new values and no problem. It's when I
use the values entered by Vodafone that it wont take them. Now to find out
why.
"SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
news:op.tezd6bkrevjsnp[ at ]enigma03...
[h]... is a Time format, just not on it's normal list
Right, back to basics.
Either work on a copy of the worksheet or *don't save* it after these
changes.
Click on the column with the times and the sum in
Format to general
Remember what these look like
Format the whole column again to Time (13:30:55 option)
Now what do you see in the cells and the sum.
Rememebr the sum may display wrong - we'll deal with that later.
Steve
On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
wrote:
[Quoted Text] > No. Still comes up with 0's.
> When I go back to format it shows it as being in time format even though
> I
> set [h]:mm:ss.
> calm calm calm!
>
> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck in
>> a
>> 24
>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
>> total
>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00.
>> There's
>> a
>> load of difference between formatting as 00:00:00, hh:mm:ss and
>> [h]:mm:ss
>>
>> "B Bear" wrote:
>>
>>> Getting annoyed now!!!
>>> Now where's my base 60 calculator?
>>>
>>>
>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>>> > No luck so far
>>> > -----
>>> > 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.
>>> > :-(
>>> >
|
|
Went through a selection of Voda values and deleted the first 0 and it
worked. Tell me I don't have to do that for all the values :-(
so ended up with 0:00:12 for instance.
"B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
news:ecu4to$o43$1$8302bc10[ at ]news.demon.co.uk...
[Quoted Text] > Hi
> Off to work so if I'm a bit slow getting back you know why.
> Just did that. In general the sum is just 0.
> In time the sum is 00:00:00.
> The sum box has the range in it
> "SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
> news:op.tezd6bkrevjsnp[ at ]enigma03...
> [h]... is a Time format, just not on it's normal list
>
> Right, back to basics.
> Either work on a copy of the worksheet or *don't save* it after these
> changes.
>
> Click on the column with the times and the sum in
> Format to general
>
> Remember what these look like
> Format the whole column again to Time (13:30:55 option)
>
> Now what do you see in the cells and the sum.
>
> Rememebr the sum may display wrong - we'll deal with that later.
>
> Steve
>
> On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
> wrote:
>
>> No. Still comes up with 0's.
>> When I go back to format it shows it as being in time format even though
>> I
>> set [h]:mm:ss.
>> calm calm calm!
>>
>> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
>> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck
>>> in a
>>> 24
>>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
>>> total
>>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
>>> a
>>> load of difference between formatting as 00:00:00, hh:mm:ss and
>>> [h]:mm:ss
>>>
>>> "B Bear" wrote:
>>>
>>>> Getting annoyed now!!!
>>>> Now where's my base 60 calculator?
>>>>
>>>>
>>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>>>> > No luck so far
>>>> > -----
>>>> > 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.
>>>> > :-(
>>>> >
>
>
|
|
B Bear here my last two posts are displayed wrong way round. Just need to
find out why I can't use the Voda values given and need to delete the first
zero
"B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
news:ecu54e$o88$1$8302bc10[ at ]news.demon.co.uk...
[Quoted Text] > Ah! being dim! Just tried it entering new values and no problem. It's when
> I use the values entered by Vodafone that it wont take them. Now to find
> out why.
> "SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
> news:op.tezd6bkrevjsnp[ at ]enigma03...
> [h]... is a Time format, just not on it's normal list
>
> Right, back to basics.
> Either work on a copy of the worksheet or *don't save* it after these
> changes.
>
> Click on the column with the times and the sum in
> Format to general
>
> Remember what these look like
> Format the whole column again to Time (13:30:55 option)
>
> Now what do you see in the cells and the sum.
>
> Rememebr the sum may display wrong - we'll deal with that later.
>
> Steve
>
> On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
> wrote:
>
>> No. Still comes up with 0's.
>> When I go back to format it shows it as being in time format even though
>> I
>> set [h]:mm:ss.
>> calm calm calm!
>>
>> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
>> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck
>>> in a
>>> 24
>>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
>>> total
>>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
>>> a
>>> load of difference between formatting as 00:00:00, hh:mm:ss and
>>> [h]:mm:ss
>>>
>>> "B Bear" wrote:
>>>
>>>> Getting annoyed now!!!
>>>> Now where's my base 60 calculator?
>>>>
>>>>
>>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>>>> > No luck so far
>>>> > -----
>>>> > 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.
>>>> > :-(
>>>> >
>
>
|
|
Most likely these values are text, and not actual times. Copy a blank cell,
select your list of times, do a paste special, and select Add. See if that
solves your problem.
"NewsGroups" wrote:
[Quoted Text] > B Bear here my last two posts are displayed wrong way round. Just need to
> find out why I can't use the Voda values given and need to delete the first
> zero
> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
> news:ecu54e$o88$1$8302bc10[ at ]news.demon.co.uk...
> > Ah! being dim! Just tried it entering new values and no problem. It's when
> > I use the values entered by Vodafone that it wont take them. Now to find
> > out why.
> > "SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
> > news:op.tezd6bkrevjsnp[ at ]enigma03...
> > [h]... is a Time format, just not on it's normal list
> >
> > Right, back to basics.
> > Either work on a copy of the worksheet or *don't save* it after these
> > changes.
> >
> > Click on the column with the times and the sum in
> > Format to general
> >
> > Remember what these look like
> > Format the whole column again to Time (13:30:55 option)
> >
> > Now what do you see in the cells and the sum.
> >
> > Rememebr the sum may display wrong - we'll deal with that later.
> >
> > Steve
> >
> > On Sun, 27 Aug 2006 17:57:37 +0100, B Bear <teign2nz[ at ]yahoo.co.uk.nospam>
> > wrote:
> >
> >> No. Still comes up with 0's.
> >> When I go back to format it shows it as being in time format even though
> >> I
> >> set [h]:mm:ss.
> >> calm calm calm!
> >>
> >> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
> >> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
> >>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck
> >>> in a
> >>> 24
> >>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
> >>> total
> >>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
> >>> a
> >>> load of difference between formatting as 00:00:00, hh:mm:ss and
> >>> [h]:mm:ss
> >>>
> >>> "B Bear" wrote:
> >>>
> >>>> Getting annoyed now!!!
> >>>> Now where's my base 60 calculator?
> >>>>
> >>>>
> >>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
> >>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
> >>>> > No luck so far
> >>>> > -----
> >>>> > 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.
> >>>> > :-(
> >>>> >
> >
> >
>
>
>
|
|
Cheers to eeryone for their help.
Got there using...Oh damn forgot! 13: something: something.
But will try the paste special idea.
"kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
news:A18CC960-73EA-4C56-BD42-04722E642B55[ at ]microsoft.com...
[Quoted Text] > Most likely these values are text, and not actual times. Copy a blank
> cell,
> select your list of times, do a paste special, and select Add. See if
> that
> solves your problem.
>
> "NewsGroups" wrote:
>
>> B Bear here my last two posts are displayed wrong way round. Just need to
>> find out why I can't use the Voda values given and need to delete the
>> first
>> zero
>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>> news:ecu54e$o88$1$8302bc10[ at ]news.demon.co.uk...
>> > Ah! being dim! Just tried it entering new values and no problem. It's
>> > when
>> > I use the values entered by Vodafone that it wont take them. Now to
>> > find
>> > out why.
>> > "SteveW" <sj_walton[ at ]nothotmail.com> wrote in message
>> > news:op.tezd6bkrevjsnp[ at ]enigma03...
>> > [h]... is a Time format, just not on it's normal list
>> >
>> > Right, back to basics.
>> > Either work on a copy of the worksheet or *don't save* it after these
>> > changes.
>> >
>> > Click on the column with the times and the sum in
>> > Format to general
>> >
>> > Remember what these look like
>> > Format the whole column again to Time (13:30:55 option)
>> >
>> > Now what do you see in the cells and the sum.
>> >
>> > Rememebr the sum may display wrong - we'll deal with that later.
>> >
>> > Steve
>> >
>> > On Sun, 27 Aug 2006 17:57:37 +0100, B Bear
>> > <teign2nz[ at ]yahoo.co.uk.nospam>
>> > wrote:
>> >
>> >> No. Still comes up with 0's.
>> >> When I go back to format it shows it as being in time format even
>> >> though
>> >> I
>> >> set [h]:mm:ss.
>> >> calm calm calm!
>> >>
>> >> "kassie" <kassie[ at ]discussions.microsoft.com> wrote in message
>> >> news:3C30890E-6EFF-4CD8-912B-20080A477256[ at ]microsoft.com...
>> >>> No need to get annoyed! If you format as hh:mm:ss, you will be stuck
>> >>> in a
>> >>> 24
>> >>> hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get
>> >>> a
>> >>> total
>> >>> of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00.
>> >>> There's
>> >>> a
>> >>> load of difference between formatting as 00:00:00, hh:mm:ss and
>> >>> [h]:mm:ss
>> >>>
>> >>> "B Bear" wrote:
>> >>>
>> >>>> Getting annoyed now!!!
>> >>>> Now where's my base 60 calculator?
>> >>>>
>> >>>>
>> >>>> "B Bear" <teign2nz[ at ]yahoo.co.uk.nospam> wrote in message
>> >>>> news:ecpucr$c4n$1$830fa7a5[ at ]news.demon.co.uk...
>> >>>> > No luck so far
>> >>>> > -----
>> >>>> > 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.
>> >>>> > :-(
>> >>>> >
>> >
>> >
>>
>>
>>
|
|
|