Adding times in hh:mm

[mattyn]

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

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

 

[Fluff]

Sounds like the cells also contain a date element, rather than just time

 

[mattyn]

Don't know how that happened but seems to have fixed it. Fat fingers typing maybe!

Many thanks.

 

[Fluff]

You're welcome & thanks for the feedback.