How to Add Hours and Minutes to current Time .

[Rozeanna Jerry]

Hi every one..I am trying to add 8 hours 15 minutes to current time and show the new time on a text box. How would I do that.?

For example if the current time is 8:00am then adding 8 hours 15 minutes should show 4:15pm.

Please help.

Anna

[colintis]

Using the function DateAdd will do the work, but the function only do one type of calculation at a time, so you can either convert the hours to minutes make a total add up, or use one DateAdd for hours, one for minutes.

Dim LDate As Date

LDate = DateAdd ("n", 495, Time())

"n" represent minutes, and 495 is adding 495 minutes (8hrs and 15mins) to Time(). But use Now() instead if you are adding time that pass 12 AM to another day.

[Rozeanna Jerry]

Thanks..worked out for me..