Hi All
This one is baffling me.
Have a number of test worksheets with a column of times ( times to complete road trip stages) such as
and so on.
The column is custom number formatted as hh:mm
I want to calculate the total time so use the formula in A7 =sum(A1:A6) custom number formatted as [h]:mm and it works it perfectly as 30:47.
Now applying exactly the same process to the live s/s, I have Column N3 to N96 custom formatted as hh:mm - most cells have values in - others are blank - all are formatted and typed correctly (have checked and double checked).
In Cell N97 (formatted to custom number [h]:mm, I have the formula =sum(N3:N96)
The answer it gives me is 6446073:15 when it should be about 196:15.
Does anyone have any idea what I have done wrong please?
Thanks in advance.
Matt
This one is baffling me.
Have a number of test worksheets with a column of times ( times to complete road trip stages) such as
03:23 |
02:45 |
05:19 |
07:56 |
06:23 |
05:01 |
=sum(A1:A6) |
and so on.
The column is custom number formatted as hh:mm
I want to calculate the total time so use the formula in A7 =sum(A1:A6) custom number formatted as [h]:mm and it works it perfectly as 30:47.
Now applying exactly the same process to the live s/s, I have Column N3 to N96 custom formatted as hh:mm - most cells have values in - others are blank - all are formatted and typed correctly (have checked and double checked).
In Cell N97 (formatted to custom number [h]:mm, I have the formula =sum(N3:N96)
The answer it gives me is 6446073:15 when it should be about 196:15.
Does anyone have any idea what I have done wrong please?
Thanks in advance.
Matt