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