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

[Guest]

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

 

[Guest]

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

 

[Guest]

=SUM(A1:A2)

Format as hh:mm

 

[Lynne]

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