On Fri, 12 Aug 2005 13:57:01 -0700, tawtrey(remove this
osoft.com wrote:

Not sure quite how to do this...

I have a cell (A1) which I have formatted to read the date and time
(MM/DD/YYYY HH:MM AM/PM). That is my starting time. What I want to do now
is be able to input a time period in hours (A2) and have another cell (B1)
add those hours to A1 so B1 will read the "ending time" - formatted with the
(MM/DD/YYYY HH:MM AM/PM) format. Is this possible?

Thanks!

If the time period in A2 is entered as a number of hours, (e.g. for 2 hrs you
enter the number 2; or for 3 1/2 hours you enter 3.5 or 3 1/2), then:

B1: =A1 + A2/24


--ron