In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
when the total is greater than a day (25.33333), but it doesn't.

What will?

Regards Glyn

What are the values in A2:A6 and what result *do* you get?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glyndotcom" <(E-Mail Removed)> wrote in message newsF40553A-C2E4-4EA6-9542-(E-Mail Removed)...
| In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
| when the total is greater than a day (25.33333), but it doesn't.
|
| What will?
|
| Regards Glyn

=SUM(A2:A6)*24 yields the sum of A2 to A6 multiplied by 24; which does work.

You have some options to check the value is greater than 24; a IF condition,
e.g.

=IF(SUM(A2:A6)*24<24,SUM(A2:A6)*24," ")

which shows the value if it is less 24 or a blank if not

also consider using conditional formatting to change the appearance of the
cell depending on its value.


--
Cheers
Nigel



"Glyndotcom" <(E-Mail Removed)> wrote in message
newsF40553A-C2E4-4EA6-9542-(E-Mail Removed)...
> In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours
> worked
> when the total is greater than a day (25.33333), but it doesn't.
>
> What will?
>
> Regards Glyn

Are there really apostrophes before and after the formula?

Stefi


„Glyndotcomâ€� ezt Ã*rta:

> In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
> when the total is greater than a day (25.33333), but it doesn't.
>
> What will?
>
> Regards Glyn

On Tue, 3 Oct 2006 03:56:02 -0700, Glyndotcom
<(E-Mail Removed)> wrote:

>In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
>when the total is greater than a day (25.33333), but it doesn't.
>
>What will?
>
>Regards Glyn

It is hard to tell what's going on since you give so little detail.

The formula works.

Common reasons for unexpected results with time summing include bad data or bad
formatting.
--ron

Have you checked the format of the cell

Custom Time format of [h]:mm:ss or ust [h]:mm

This will then print Hours above 24

Steve

On Tue, 03 Oct 2006 11:56:02 +0100, Glyndotcom
<(E-Mail Removed)> wrote:

> In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours
> worked
> when the total is greater than a day (25.33333), but it doesn't.
>
> What will?
>
> Regards Glyn

I believe what everyone is saying is that the function works perfectly,
it is your logic that is flawed. Give us some more details on what it
is you're trying to do so we can help you out. And I might also
suggest posting this in the worksheet functions group not the
programming group.


Ron Rosenfeld wrote:
> On Tue, 3 Oct 2006 03:56:02 -0700, Glyndotcom
> <(E-Mail Removed)> wrote:
>
> >In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
> >when the total is greater than a day (25.33333), but it doesn't.
> >
> >What will?
> >
> >Regards Glyn
>
> It is hard to tell what's going on since you give so little detail.
>
> The formula works.
>
> Common reasons for unexpected results with time summing include bad data or bad
> formatting.
> --ron

Niek,

Thanks for the email, A2:A6 should add up to 25.3333, without the *24, it
gives 1:20, with the *24, it gives 8:00.

I am trying to add up working hours. The formula is from the Help Time
Function menu.

I can only assume the help menu is wrong, it actually multiplies the total,
but still gives it in a 24 hour formate.

"Niek Otten" wrote:

> What are the values in A2:A6 and what result *do* you get?
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Glyndotcom" <(E-Mail Removed)> wrote in message newsF40553A-C2E4-4EA6-9542-(E-Mail Removed)...
> | In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
> | when the total is greater than a day (25.33333), but it doesn't.
> |
> | What will?
> |
> | Regards Glyn
>
>
>

If you format the 1:20 as Custom [h]:mm you'll see that it actually is 25:20, which indeed is 25.3333 hours.
Multiply by 24, format as General and you get 25.3333

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glyndotcom" <(E-Mail Removed)> wrote in message news:990450FE-7626-41D1-B374-(E-Mail Removed)...
| Niek,
|
| Thanks for the email, A2:A6 should add up to 25.3333, without the *24, it
| gives 1:20, with the *24, it gives 8:00.
|
| I am trying to add up working hours. The formula is from the Help Time
| Function menu.
|
| I can only assume the help menu is wrong, it actually multiplies the total,
| but still gives it in a 24 hour formate.
|
| "Niek Otten" wrote:
|
| > What are the values in A2:A6 and what result *do* you get?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > "Glyndotcom" <(E-Mail Removed)> wrote in message
newsF40553A-C2E4-4EA6-9542-(E-Mail Removed)...
| > | In Excel the function '=SUM(A2:A6)*24' is suppose to give Total hours worked
| > | when the total is greater than a day (25.33333), but it doesn't.
| > |
| > | What will?
| > |
| > | Regards Glyn
| >
| >
| >