3 replies to this topic

[Nuno Elvas Silva]

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

[fmanera]

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

[Nuno Elvas Silva]

 

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

[Simon Davis]

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

 

  Simon

Attached Files

•  DataManipulation.phxproj   238.51KB   478 downloads