Menu
I have in cel A1 with the following contents:
7:30:43 which is a time.
But now i want to use a formula to add one hour. What is the best way or how can i do this?
777
Formula Method The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one. Copy the formula in A2 down the rest of the column to continuously increment the preceding number.
To add a given number of hours to a time, you can add hours divided by 24, or use the TIME function. Note: make sure results are formatted as time. Times in Excel are factional values of 24 hours. One hour of time is 1/24, and 1 minute of time is 1/(24*60) = 1/1440.
=A1+TIME(1,0,0) Although, maybe this should be posted on Super User.
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
