View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Summing a Formula

=SUM(--B46:F46)

That would have to be array entered.

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello Debbie,

Use
=SUM(--B46:F46)
and format as [h]:mm

Regards,
Bernd