Date and Time
 

I need to know how to add hours to a time. Example: I am trying to schedule
medicine administration to one patient with three different medicines
administered at different times. Does Excel allow you to do this?

Date and Time
 

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