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