Adding times

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I am using Excel 97
I have a column that has a list of time in hours and
minutes, 34:12 (thirty foru hours and 12 minutes). How can
I add these and also do an average.

I would like to be be able, forsinstance to add 12:34 plus
23:52 minutes and get 36:26. HELP Also need to average
this as well.

Linda
 
Linda

just add the cells and format the result as Custom [hh]:mm

Regards

Trevor
 
Hi Linda,

Format the sum cell as [hh]:mm, and it will roll-over 24 hours.

Average as you would any set of numbers, time is no different, just ensure
the average cell is formatted as time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top