Date/Time format for Relative actual time calculation

Dear all
I pretend to calculate the actual time of a blood sampling in relation to dosing Date/Time.
Data example:
Dosing: 2018-12-25 07:00
Blood sampling: 2018-12-26 19:00
How can I do this calculation. I have tried several approaches without result!
Rgds

Dear Nuno,

You can copy and paste dosing date&time and sampling dosing&time in a Excel spreadsheet. In a third cell apply this formula (sampling&time cell - dosing&time cell). Finally copy and paste the column “actual time” in Phoenix.
Hope you find it usefull.
Best regards
Francesco

Dear Francesco

Thank you for your suggestion. That is the easiest way. However, from a Quality Control and tracebility of the data transformation, you should not use copy/paste to excel and back again to Phoenix. All the transformations should be ideally performed in Phoenix.

We will wait for other suggestions. I’ve also posted a ticket in Certara support. So, if a solution comes from it, I’ll post it.

Nevertheless, thanks for your input!

Rgds

Dear Nuno, here is a worked example that shows how to parse your datetime values for calculation. I hope this helps

Simon

DataManipulation.phxproj (239 KB)