| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date and Time
If you have a time in cell A1, the following formula will add 1
hour to it. =A1+TIME(1,0,0) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nurse in need of HELP" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Hybrid Mode
