Ahh alright, I see now.

Thanks... OP 😛

Im afraid to ask... OP?

I see what you are doing now and it does work thanks.

The thing is that the table I am retrieving the data from is a production/live...

Hi guys,

Thanks, your method is really fast, but it does not give me the results I am looking for.

Basically I am looking for a total time. so if I have...

Nabila:

Thanks, your solution works well, and does not have any issues with that dataset which I posted either.

Carl Federl:

Thanks to you too, the result your SQL gives is actually exactly...

Ok dont worry.

I suppose I can give you some background.

The calculation you showed me, I added into the SELECT statement which is being used by an application I am working...

Hi, karthikeyan

I need to borrow your mind again... for some reason with certain data, the minutes do not seem to increment over to hours properly, here is an example set...

Hi guys,

Thanks again for all of your help and suggestions,

karthikeyan,

Your method works perfectly, after working through it carefully it is actually a lot simpler than it looks at first glance...

My head... it hurts...

Jokes, thanks for all of your suggestions so far.

I am busy trying them all out and I will get back to you once I have made sense...