Time Increments (summing value) - need help wih formula

[auswtz]

I have no idea where I am going wrong would really appreciate anyones help.
PS> I have tried 2 different formulas on Column M & N - both are not working.
I am thinking it could be my formula on column G perhaps how I have set categorisation?

[rylo]

Hi

Firstly, you will have to convert all your entries in the range A16:A72 into real time entries. Basically, select A16, edit, and then save, and you should note that the entry formats to a number in time format, and right aligns.

Then in say L1 enter the formula

Please Login or Register  to view this content.

and copy down to L50.

See how that goes.

rylo

[auswtz]

Hi Rylo,
Thank you for your response, it doesn't seem to work?
The Data on column A to E is extracted/pasted as text, is there a way where we don't have to manipulate the raw data?

[rylo]

Hi

OK, try this, based on the example file.

F16:

Please Login or Register  to view this content.

Copy down to F72
L3:

Please Login or Register  to view this content.

Copy down to L50.

This will bring back the totals of 16 and 71 in cells L18 and L19 as per your first post.

rylo

[auswtz]

Rylo, thank you so much for your help with this.