Syntax to add the time without the date

[Dheepak]

Hi,

Using Now() function i have displayed the date and time in cells(4,1) as 2/10/2015 15:20. However, in next cell i need to display the time with the addition of 2hrs without changing the format. I'm getting time mismatch error if i use the below code.

Code:
Cells(38, 8) = Now() + Time(2, 0, 0)

can anyone please let me know how to get display the output as 2/10/2015 17:20.

Thanks in advance.

Regards,
Dheepak.

 

[steve the fish]

You could add:

+ TimeValue("02:00:00")

 

[hippiehacker]

Now() + 2 / 24

 

[Dheepak]

Thanks a lot, steve.!!!!!!! i got the expected output.. Thank you so much

Best Regards,
Dheepak

 

[Dheepak]

Thank you so much, hippiehacker. Both the codes are giving the same result as expected. Thank you much

Best Regards,
Dheepak

 

[Rick Rothstein]

Hi,

Using Now() function i have displayed the date and time in cells(4,1) as 2/10/2015 15:20. However, in next cell i need to display the time with the addition of 2hrs without changing the format. I'm getting time mismatch error if i use the below code.

Code:
Cells(38, 8) = Now() + Time(2, 0, 0)

can anyone please let me know how to get display the output as 2/10/2015 17:20.

Time, the way you are trying to use it, is an Excel worksheet function... VB's TimeSerial function is its equivalent...

Cells(38, 8) = Now() + TimeSerial(2, 0, 0)

Note: The reason for the particular error you got is because VB has a Time() function, but it takes no arguments (the arguments you tried to pass is what generated the error) and it returns the current computer system's time value. You can also use Time as a statement and set your computer system's time with it.

 

[Dheepak]

Thank you so much, Rick for providing the background of the error. Now, I can able to differentiate and understood the mistake that happen in the code. Thank you once again

Best Regards,
Dheepak