View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill[_7_] Bill[_7_] is offline
external usenet poster
 
Posts: 3
Default Need formula help

Hi everyone:

I made a time sheet pretty basic. However when I want to add the times from
A1 through A45, I thought I would type it like "=sum(A1:A45)" However when I
use this formula I end up with an error all the time. Understand that the
values in those cells to be added are Hours and Minutes. So I need the
formula to be totaled in Hours and Minutes.

Thanx everyone for all your help.

Bill