D Dave S Nov 10, 2005 #1 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
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 Nov 10, 2005 #2 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
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
D Dave S Nov 10, 2005 #3 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 Click to expand...
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 Click to expand...
A Anne Troy Nov 10, 2005 #4 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...
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...
