Time to take a pill

[DENWARD]

I need to take a pill every eight hours for the next 10 days. I took the first pill today at 11 AM. Is there an excel formula to calculate what time I need to take all of the subsequent doses.

 

[MARK858]

Maybe...

Book1
	A	B
1	12/12/2019 11:00:00	12/12/2019 11:00:00
2	12/12/2019 19:00:00	12/12/2019 19:00:00
3	13/12/2019 03:00:00	13/12/2019 03:00:00
4	13/12/2019 11:00:00	13/12/2019 11:00:00
5	13/12/2019 19:00:00	13/12/2019 19:00:00
6	14/12/2019 03:00:00	14/12/2019 03:00:00
7	14/12/2019 11:00:00	14/12/2019 11:00:00
8	14/12/2019 19:00:00	14/12/2019 19:00:00
9	15/12/2019 03:00:00	15/12/2019 03:00:00
10	15/12/2019 11:00:00	15/12/2019 11:00:00
11	15/12/2019 19:00:00	15/12/2019 19:00:00
12	16/12/2019 03:00:00	16/12/2019 03:00:00
13	16/12/2019 11:00:00	16/12/2019 11:00:00
14	16/12/2019 19:00:00	16/12/2019 19:00:00
15	17/12/2019 03:00:00	17/12/2019 03:00:00
16	17/12/2019 11:00:00	17/12/2019 11:00:00
17	17/12/2019 19:00:00	17/12/2019 19:00:00
18	18/12/2019 03:00:00	18/12/2019 03:00:00
19	18/12/2019 11:00:00	18/12/2019 11:00:00
20	18/12/2019 19:00:00	18/12/2019 19:00:00
21	19/12/2019 03:00:00	19/12/2019 03:00:00
22	19/12/2019 11:00:00	19/12/2019 11:00:00
23	19/12/2019 19:00:00	19/12/2019 19:00:00
24	20/12/2019 03:00:00	20/12/2019 03:00:00
25	20/12/2019 11:00:00	20/12/2019 11:00:00
26	20/12/2019 19:00:00	20/12/2019 19:00:00
27	21/12/2019 03:00:00	21/12/2019 03:00:00
28	21/12/2019 11:00:00	21/12/2019 11:00:00
29	21/12/2019 19:00:00	21/12/2019 19:00:00
30	22/12/2019 03:00:00	22/12/2019 03:00:00
31	22/12/2019 11:00:00	22/12/2019 11:00:00
32	22/12/2019 19:00:00	22/12/2019 19:00:00
Sheet1

Cell Formulas
Range	Formula
A2:A32	A2	=A1+TIME(8,0,0)
B2:B32	B2	=B1+1/3

 

[DENWARD]

Mark, Mr Excel and people like you are a national treasure. Thank you very much for your recommendation. It works great

 

[MARK858]

You're welcome, don't about national treasure though (the people on the board are pretty International and the missus has just said she can think of words other than treasure)

 

[DENWARD]

no offense intended

 

[MARK858]

I'm not offended (it gave the missus a laugh though)