Actually I can make use of both ideas for 2 seperate reports. I think for this project, converting to milliseconds is important so I can compare the different stages very...

I will try all the above tomorrow morning and feedback. Genuinely, thanks for all the help so far to all of you.

Thanks for that, its similar toExcel's datedif fuction (just about). I can use that to work out the exact difference between the different stages of the calls.

Can I please ask,...

In the original post it sounded like things were being rounded down in the change over to TIME, not up, when compared to the original DATETIME value which does not...

Thank you for that. My biggest issue is i'm calling from a database I don't have full access to so it's difficult for me to know what format the data...

Thanks for that again. I'll give it a try in the morning and let you know the outcome.

J 🙂

Thanks Hugo, I thought something must be rounding up somewhere. Is there a way to stop this rounding up please?

I should add, the SQL I am using is being executed...