Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and Time
The answer is yes, you can do this. But the specifics depend on the format
of the data you've got for hours and time. For example, if I've got 3/25/06 11:00 in one cell and 8:00 in another, then I can just add them together. If I've got 3/25/06 11:00 in A1 and 8 in B1 (representing 8 hours), then my formula would be =a1+b1/24. (the number 1 represents a day to Excel; if you're using 1 to represent an hour, we have to divide by 24 to get in sync). "Nurse in need of HELP" wrote: 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 |