Yes excel does allow you to do this. It depends how your times and dates
are entered. If it is truly a time and date eg 10/09/06 12:00 The value
is stored as a number of days. The part of the value after the decimal
point is the time. For example .5 =midday 0.75=6.00pm. Without seeing
an example of the spreadsheet it is difficult to give you exact
advice,

But if cell A1 contained 7:00 am and the drugs were to be administered
every 6 hours

in A2 put =a1+6/24
then copy this down to a3, a4 etc

If you are more specific I could probabl;y be more helpful

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=526591