cell 4 =cell2 + cell3 * 15 / 1440

time and dates are stored in Excel as a serial number, the remainder
equals the fraction of a day since midnight so 5 times 15 minutes
divided by 1440 minutes per day or 1.25hours/24 hours=.05208333333

Mike wrote:

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?