"DateAdd" is driving me crazy

[Oseitutuakrasi]

I have two textboxes as follows:

TextBox1.value=Time() ' This gives me the correct time (e.g. 11:12:56)
I want to add 90 minutes to the current time and display in the second textbox:

TextBox2.value=DateAdd("n", 90, Time()). 'For reasons I cannot figure out, this gives me 31/12/1899 (followed by the time with the 90 minutes added)

I cannot figure out how to get rid of the "31/12/1899" part. Can anybody help, please?

Thanks Guys!

 

[RoryA]

Not sure why it is doing that, but this should work: Format(DateAdd("n", 90, Time()), "hh:mm:ss")

 

[Oseitutuakrasi]

Not sure why it is doing that, but this should work: Format(DateAdd("n", 90, Time()), "hh:mm:ss")

Thanks a lot my friend. My formatting was wrong. I copied and pasted your code and ...BINGO!!
Many thanks again.

 

[Oseitutuakrasi]

Not sure why it is doing that, but this should work: Format(DateAdd("n", 90, Time()), "hh:mm:ss")

Hi RoryA, to my surprise, my original code DateAdd("n", 90, Time()) which was giving me problem
is now working together with yours. Just can't figure out why. Thanks for your help.