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).
quot;Nurse in need of HELPquot; wrote:
gt; I need to know how to add hours to a time. Example: I am trying to schedule
gt; medicine administration to one patient with three different medicines
gt; administered at different times. Does Excel allow you to do this?
- Jul 20 Thu 2006 20:08
Date and Time
close
全站熱搜
留言列表
發表留言