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)