Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |