# Calculating Actual Time after First Dose using 1 date column and 1 time column in data wizard

**URL:** <https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303>\
**Category:** Phoenix WNL basics\
**Created:** [April 9, 2018, 6:01pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303 "2018-04-09T18:01:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hamuro](https://avatars.discourse-cdn.com/v4/letter/h/91b2a8/32.png) [@hamuro](https://forum.certara.com/u/hamuro)\
**Post date:** [April 9, 2018, 6:01pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303/1 "2018-04-09T18:01:24Z")

</div>

I have one column for date of PK sample and one column for time (based on 24 hr clock time). Using these two columns, would like to calculate actual time after first dose for each subject. Can this be done using data wizard?

---

<div class="post-metadata">

**Author:** ![ana.henry](https://sea1.discourse-cdn.com/certara/user_avatar/forum.certara.com/ana.henry/32/2578_2.png) [@ana.henry](https://forum.certara.com/u/ana.henry)\
**Post date:** [April 9, 2018, 6:08pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303/2 "2018-04-09T18:08:49Z")

</div>

What is your date format and your clock format? Please send a project or a sample datafile. Some times you can use the **data wizard\>change from baseline** to do this but it depends on the format.

---

<div class="post-metadata">

**Author:** ![hamuro](https://avatars.discourse-cdn.com/v4/letter/h/91b2a8/32.png) [@hamuro](https://forum.certara.com/u/hamuro)\
**Post date:** [April 9, 2018, 6:31pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303/3 "2018-04-09T18:31:11Z")

</div>

[Date\_Time.pdf](https://forum.certara.com/uploads/short-url/pGYk3lAYfIHcKum7sgpkilmig39.pdf) (30.3 KB)

Data and time format attached.

Thanks,

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [April 9, 2018, 6:39pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303/4 "2018-04-09T18:39:19Z")

</div>

Lora, it would be much easier for people to help you if you attached a project containing this worksheet, ideally stating which version of Phoenix are using.

if you are worried about data confidentialiy you can just include a subject ID with visit\_id\_xxxxx

columns, plus sampling\_date and sampling\_time.

Simon

---

<div class="post-metadata">

**Author:** ![hamuro](https://avatars.discourse-cdn.com/v4/letter/h/91b2a8/32.png) [@hamuro](https://forum.certara.com/u/hamuro)\
**Post date:** [April 9, 2018, 6:48pm UTC](https://forum.certara.com/t/calculating-actual-time-after-first-dose-using-1-date-column-and-1-time-column-in-data-wizard/3303/5 "2018-04-09T18:48:57Z")

</div>

[Date\_Time\_example.phxproj](https://forum.certara.com/uploads/short-url/7Zsoh5s8Rd2GFt0q07dQ1bJJr5s.phxproj) (37.9 KB)

Hi Simon,

[Date\_Time\_example.phxproj](https://forum.certara.com/uploads/short-url/7Zsoh5s8Rd2GFt0q07dQ1bJJr5s.phxproj) (37.9 KB)