# What formula do I use to project future timepoints

June 13, 2013 at 13:47:48
Specs: Windows 7
 I have a specific starting time and several timepoints thereafter that are to occur at a specific set of mins/hours later. I want to be able to plug in the starting time and have all of the subsequent times populate automatically. For example, I have to dose a patient with a medication then do several breathing tests one 5 mins post-dose, 15min post-dose, 1hr, 2hr, etc.. So if I dose them at 9am the first one is due at 9:05am, then 9:20am and so on. How do I create a formula for this?

See More: What formula do I use to project future timepoints

#1
June 13, 2013 at 14:55:16
 Two questions:My crystal ball is out for repair this week and since you have posted in the Programming Forum, what program / language are you using?You state that the times are 5 min post-dose then 15 min post-dosebut in your example you give Accumulated Time.9:00am Dose, then 5 Min = 9:05 +15 Min = 9:20but post-dose would be9:00am Dose, then 5 Min = 9:05 + 15 Min from Dose time = 9:15Which are you looking for, Dose Time or Accumulated Time?MIKE

Report •

#2
June 13, 2013 at 15:13:49
 Sorry about that! I made a mistake above with 9:20am. It all goes back to the original dose time. The 15min post-dose would be 9:15am. The 30min post 9:30am and so on. I apologize for making that more confusing!

Report •

#3
June 13, 2013 at 15:26:01
 Soooooo, what program / language are you using?MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
June 13, 2013 at 16:08:37
 Microsoft Excel Windows Version 7

Report •

#5
June 13, 2013 at 16:22:08
 For future reference, Excel questions are best asked in the Office Software ForumTry this:With your Dose Time in cell A1:For +5 Min - In cell B1 enter the formula: =A1+TIME(,5,)For +15 Min -In cell C1 enter the formula: =A1+TIME(,15,)For +1 Hr -In cell D1 enter the formula: =A1+TIME(1,,)For +2 Hr -In cell E1 enter the formula: =A1+TIME(2,,)The Time function uses: =TIME(Hour,Min,Sec)See how that work for you.MIKEhttp://www.skeptic.com/

Report •