Time in Excel is not kept in hours and minutes. It is kept as a decimal
fraction representing a portion of 24 hours. For example 1 am is 1/24 =
0.04166666666666667. 6am is 6/24 = 0.25, 12 noon is 12/24 = .5 It would be
helpful is you told us what error you're getting. You have to be
careful dealing with time. Did you format the time formula cell as [h]mm ?

Tyro



"Bill" wrote in message
. ..
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