How do I add up time and minutes in a spreadsheet?
 

I need to add the total time and minutes (hours worked) in a colum, but when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not time
format.

Example: Monday 7:55 NOT: Monday 7:55
Tuesday 8:10 Tuesday 8:10
= 16:05 = 15:65

I cant find anything in the help that addresses this.

Thanks

How do I add up time and minutes in a spreadsheet?
 

I don't see any cicumstances in which you can get 15:65 as a result.

Do you mean A1 contains 7.55 and and A2 8.10 in which case the sum will be
15.65

How do you arrive at the daily hours? If they are manually input then input
with a colon, if they are calculated by formula and you have something like

=(D1-C1)*24

then remove the *24 to give a time value rather than a decimal hours values

"Todd B." wrote:

I need to add the total time and minutes (hours worked) in a colum, but when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not time
format.

Example: Monday 7:55 NOT: Monday 7:55
Tuesday 8:10 Tuesday 8:10
= 16:05 = 15:65

I cant find anything in the help that addresses this.

Thanks

How do I add up time and minutes in a spreadsheet?
 

=SUM(A1:A2)

Format as hh:mm


"Todd B." wrote:

I need to add the total time and minutes (hours worked) in a colum, but when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not time
format.

Example: Monday 7:55 NOT: Monday 7:55
Tuesday 8:10 Tuesday 8:10
= 16:05 = 15:65

I cant find anything in the help that addresses this.

Thanks

How do I add up time and minutes in a spreadsheet?
 

Feel that Todd is not formatting the cells with contain 7:55 and 8:10 as
hh:mm

"Teethless mama" wrote in message
...
=SUM(A1:A2)

Format as hh:mm


"Todd B." wrote:

I need to add the total time and minutes (hours worked) in a colum, but
when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not
time
format.

Example: Monday 7:55 NOT: Monday 7:55
Tuesday 8:10 Tuesday 8:10
= 16:05 =
15:65

I cant find anything in the help that addresses this.

Thanks