ExcelBanter - cannot sum time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cannot sum time (https://www.excelbanter.com/excel-worksheet-functions/111220-cannot-sum-time.html)

cannot sum time

I do have a long column in which I write down flying hours:
The sum function works for 5 rows maximum. I am not able to sum 400 rows.
Any idea what to do?

Dave F

cannot sum time

SUM works for 400 rows.

=SUM(A1:A400) will not generate errors.
--
Brevity is the soul of wit.

"EZ" wrote:

I do have a long column in which I write down flying hours:
The sum function works for 5 rows maximum. I am not able to sum 400 rows.
Any idea what to do?

Toppers

cannot sum time

If the SUM appears incorrect, format cell as Custom==[h]:mm.

"EZ" wrote:

I do have a long column in which I write down flying hours:
The sum function works for 5 rows maximum. I am not able to sum 400 rows.
Any idea what to do?

All times are GMT +1. The time now is 10:43 PM.