myvar = Format(Range("a2").Value+ Range("A3").Value*15/24/60,"hh:mm
AM/PM")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
I have an Excel sheet with the date in one cell (formated for date) and
the time in another cell (formated for time). What I need to do is create a
string that has a new time based on the value of a 3rd cell.

i.e. cell 1 = 5/25/04
cell 2 = 08:00 am
cell 3 = 5

8:00 pm * 105(15 minutes for each value of cell 3) = 09:15 am

How do I do this in VB?