=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