Newbie question - Time

D

Dave S

Hi - How do I total a column of hours and minutes. I've tried =sum(a1:a5)
but it give me less than the total time.

Thanks - Dave
 
A

Anne Troy

Welcome!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

Dave S said:
Thanks Anne - Worked first time! Easy when you know how!

Anne Troy said:
Hi, Dave. you need to format that sum cell as [h]:mm
See:
http://www.officearticles.com/excel/adding_or_summing_time_in_microsoft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

Dave S said:
Hi - How do I total a column of hours and minutes. I've tried
=sum(a1:a5) but it give me less than the total time.

Thanks - Dave
Click to expand...
Click to expand...
Click to expand...
 
Top