Adding hours and minutes

[lynn]

Is there a way of adding up hours and minutes in excel?

 

[Frank Kabel]

Hi lynn
you can just simply add them. Have a look at
http://www.cpearson.com/excel/datetime.htm#AddingDates
for more information about dates/times

HTH
Frank

 

[Bob Phillips]

As long as the cells are both time, just add them as normal. You might want
to format the result cell as [h]:mm to allow for more than 24 hours.

--

HTH

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

 

[Guest]

I have tried formatting the cells to time but it doesn't
work. I need excel to recognise that there are 60 minutes
in an hour so it will add up a column of numbers e.g. 5.40
(i.e 5 hours 40 minutes etc.)

Thanks
Lynn

-----Original Message-----
As long as the cells are both time, just add them as normal. You might want
to format the result cell as [h]:mm to allow for more than 24 hours.

--

HTH

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

Is there a way of adding up hours and minutes in excel?

.

 

[Scoobee]

When keying in the time make sure you use : between hours and minutes e
15:30. That should fix it.;