1 Hour

emvella

New Member
Joined
Apr 7, 2017
Messages
46
Hi,

I want that when I copy and paste time in Column C, an extra hour is added automatically. I mean if time is 7:35, when paste time will automatically be 8:35.

This is about starting the second half of a soccer game.

https://yadi.sk/i/69TRVQvw8zVzoA
 

Computerman

Board Regular
Joined
Mar 3, 2016
Messages
90
emvella,
You did not post your code so I cannot help you with where to put the code, but to add 1 hour to a time value in excel, add 1/24 to the time value in the cell. However, when you paste something into a cell it ovrwrites whatever was in the cell originally so you will not be able to paste a time value into a cell and have it automatically be increased by one hour.
Computerman
 

Forum statistics

Threads
1,086,117
Messages
5,387,929
Members
402,089
Latest member
Exceliamus

Some videos you may like

This Week's Hot Topics

Top