Need formula help
 

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

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

Need formula help
 

Tyro:
I have attached the file. I can't get it to add the total of the column now.

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

Need formula help
 

On Mon, 11 Feb 2008 18:45:17 -0600, "Bill" wrote:

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



That's because your values are Text, and SUM ignores Text when you enter a
reference or array as an argument (see HELP).

You should just format the cell as time (e.g. h:mm or [h]:mm)
--ron

Need formula help
 

Tyro:

What I currently have going on is this. For Monday - Sunday I have a In and
Out time. For my Formula of the total hours worked for the day is
"=TEXT(D2-C2,"h:mm")" and that total is in column E2 through E9. I have used
the formula for my total hours for the week "=sum(E2:E9)" the problem is it
does not render a total.

thanx

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

Need formula help
 

Using the Text function is your problem. Excel can't add text -- it adds
numbers.

Change "=TEXT(D2-C2,"h:mm")" to "=D2-C2", and format as [h]:mm. Then the sum
will work.

Regards,
Fred.

"Bill" wrote in message
...
Tyro:

What I currently have going on is this. For Monday - Sunday I have a In
and
Out time. For my Formula of the total hours worked for the day is
and that total is in column E2 through E9. I have used
the formula for my total hours for the week "=sum(E2:E9)" the problem is
it
does not render a total.

thanx

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