View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How come the function '=SUM(A2:A6)*24' doesn't work

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