Combining date and time.

Ste1605

Hi,

I have a drop down list I want to incorporate in to a formula. The drop down box in cell H15 will populate AV5 & AW5. I want a formula to combine the date in H13 and the value in cell AV5 and in AW5 in cells AV7 & AW7. Any help greatly appreciated,

Thanks
Stephen

KAGY

Not 100% sure how you want to "combine" the data. There may be a simpler way of doing things.

Date and time in excel are handled by considering the date a number of days from 1901? and the time as a decimal (e.g. 0.5 is 12 noon). as your look up is returning a time you could just add them together.

If you want them formatted you could use string concatenation "&"

e.g. =H15&" on the " & TEXT(H13,"dd mmm yyyy")

invaderzimirl

this should work =H13+AV5 but have your cells formatted as custom and dd/mm/yyyy hh:mm as you can see from my snip

change to dd/mm/yyyy hh:mm:ss if you wnt seconds also

dont worry about the number below i was trying another method but it did not work

Ste1605

Thanks for the help guys problem is now solved.

invaderzimirl

but just for others who might search and find this can you post result ? just formula