Hi All
Wondering if anyone can help me. I have a function in my workbook returning the current time. I am using =Now() and formatted the cell B9 to Time. The contents of the cell is 14:37:40. This is fine.
I am trying to use VBA to store this value and add 2 hours to it so that the new time can be stored in a variable, and used in an email. But the value that I am receiving is 38013.6093769676! this is before I add 2 hours to it.
Is there a way or what do I have to do to add 2 hours to the current time. There is no reason why this should be collected from the workbook. I am happy for VBA to add two hours to current time!
Kindest Regards
Peter
Wondering if anyone can help me. I have a function in my workbook returning the current time. I am using =Now() and formatted the cell B9 to Time. The contents of the cell is 14:37:40. This is fine.
I am trying to use VBA to store this value and add 2 hours to it so that the new time can be stored in a variable, and used in an email. But the value that I am receiving is 38013.6093769676! this is before I add 2 hours to it.
Is there a way or what do I have to do to add 2 hours to the current time. There is no reason why this should be collected from the workbook. I am happy for VBA to add two hours to current time!
Kindest Regards
Peter