calculating time formula

[Nick]

Hi,

i want to set up a time summation calculation in excel.

for example i put in how many hours i've working on something over a number
of days down one column and a "Total hours and mins worked" cell somewhere
else just adds all my inputs in hour and min format. eg. 03:20 (ie. 3 hours
20 mins)

- thanks for any comments.

 

[Frank Kabel]

Hi
just enter your time values in Ex^cel's time format and use a formula
such as
=SUM(A1:A10)

Important: Format your target cell with the custom format [hh]:mm

 

[Jason Morin]

=SUM(A:A)/24

and format the cell as [h]:mm.

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

To convert a time, which is fractional days, to hours, I think you should
multiply rather than divide, no?

=SUM(A:A)/24

and format the cell as [h]:mm.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

i want to set up a time summation calculation in excel.

for example i put in how many hours i've working on something over a number
of days down one column and a "Total hours and mins worked" cell somewhere
else just adds all my inputs in hour and min format. eg. 03:20 (ie. 3 hours
20 mins)

- thanks for any comments.


.