ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date and Time (https://www.excelbanter.com/excel-discussion-misc-queries/79638-date-time.html)

Nurse in need of HELP

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?


Chip Pearson

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?





All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com