It might be difficult to manipulate time data in Excel, but with the correct tools, it’s easy. In this article, you will explore four ways to add 8 hours to a time in Excel. These techniques will provide you with quick and precise answers whether you are calculating working hours, dealing with time zones, or adding time to a timetable.
📁 Download Excel File
Download this file to better understand and practice with this article.
How to Add Hours to Time in Excel
In Excel, you can add a number of hours to your time. Excel stores time information as decimal numbers, with one day being represented by the number 1. So, when you want to add certain hours to your time, simply divide the number of hours by 24 hours that make up a day to get a fraction of a day in hours, then add that fraction to your time. In this section, we will add 10 hours to our time. Let’s see that step by step.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, choose the first cell in the column where you wish to see the outcome (in this case, cell D6).
- Then, enter the formula as follows:
=C6+(10/24)
- To add 10 hours to the time in cell C6, press Enter to see the result.
- Next, to duplicate the formula down to the other cells in the range, double-click Fill Handle(+), a little square in the bottom-right corner of the cell (D7 to D12).
All done! Column D‘s formula will now extend the time in column C by 10 hours and display the result in each corresponding cell.
Learn to Add 8 Hours to Time in Excel with These 4 Methods
In this article, we will explore 4 simple tricks to add 8 hours to specific times in Excel. In this journey, we will take help from basic arithmetic formulas, TIME and TIMEVALUE functions. Finally, we’ll write a VBA macro to generate the code to do this across a range at once. We will keep our dataset as simple as possible. We have taken a couple of employees’ entry times as data, and we will add 8 hours to their entry times to get their supposed exit times. Let’s get right into the central part of the article.
1. Using Basic Division Rule
You might need to change the time values you work within Excel by a specified number of hours. Excel stores time information as decimal numbers, with one day being represented by the number 1. So, when you want to add certain hours to your time, simply divide the number of hours by 24 hours that make up a day to get a fraction of a day in hours, then add that fraction to your time. You can perform mathematical operations on time values, such as addition and subtraction, using this fractional representation of time, just as you would with any other decimal number. That’s exactly how we are adding 8 hours to our entry time. Let’s see the process step by step.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, choose the first cell in the column where you wish to see the outcome (in this case, cell D6).
- Then, enter the formula as follows:
=C6+(8/24)
- To add 8 hours to the time in cell C6, press Enter to see the result.
- To duplicate the formula down to the other cells in the range, double-click Fill Handle(+), a little square in the bottom-right corner of the cell (D7 to D12).
All done! Column D‘s formula will now extend the time in column C by 8 hours and display the result in each corresponding cell.
2. Applying TIME Function
Another way we can add 8 hours to our time in Excel is by using TIME function. In Excel, the TIME function returns a time value based on hour, minute, and second variables. It is used to integrate several values into a legitimate time value. Since we are adding 8 hours, we’ll only put “8” in the hour section of the function.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, choose the first cell in the column where you wish to see the outcome (in this case, cell D6).
- Then. enter the formula as follows:
=C6+TIME(8,0,0)
- To add 8 hours to the time in cell C6, press Enter to see the result.
- Next, to duplicate the formula down to the other cells in the range, double-click Fill Handle(+), a little square in the bottom-right corner of the cell (D7 to D12).
All done! Column D‘s formula will now extend the time in column C by 8 hours and display the result in each corresponding cell.
3. Employing TIMEVALUE Function
The TIMEVALUE function in Excel is used to convert text strings representing time into actual time values for calculations. It returns a decimal number that represents the time value, which can be used in various formulas and functions. In this section, we will see how TIMEVALUE function works in our particular case.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, choose the first cell in the column where you wish to see the outcome (in this case, cell D6).
- Then, enter the formula as follows:
=C6+TIMEVALUE("8:0:0")
- To add 8 hours to the time in cell C6, press Enter to see the result.
- Next, to duplicate the formula down to the other cells in the range, double-click Fill Handle(+), a little square in the bottom-right corner of the cell (D7 to D12).
All done! Column D‘s formula will now extend the time in column C by 8 hours and display the result in each corresponding cell.
4. Embedding VBA Code
VBA (Visual Basic for Applications) macros provide a powerful way to automate repetitive tasks and perform complex operations in Excel. When it comes to adding 8 hours to time in Excel, a VBA macro can be especially useful because it can perform the calculation across a large range of cells quickly and accurately. Unlike formulas, which need to be entered into each cell individually, a VBA macro can be run with a single command, making it much more efficient for dealing with large amounts of data. Additionally, VBA macros can be easily customized to perform a wide range of operations, allowing you to add 8 hours to time in a way that fits your specific needs.
⬇️⬇️ STEPS ⬇️⬇️
- Pressing Alt+F11 will open Microsoft Visual Basic where we insert a Module from the Insert tab to open a whiteboard.
- Now copy and paste the following code into the module.
Sub AddingHours()
Dim i As Integer
For i = 6 To 12
Cells(i, 4) = Cells(i, 3) + TimeValue("8:00:00")
Next i
End Sub
- Finally, press F5 to execute the code.
How to Add Hours to Date and Time in Excel
In Excel, you can add a number of hours to your date and time. Excel stores time information as decimal numbers, with one day being represented by the number 1. So, when you want to add certain hours to your date and time, simply divide the number of hours by 24 hours that make up a day to get a fraction of a day in hours, then add that fraction to your time. In this section, we will add 8 hours to our date and time. Let’s see that step by step.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, choose the first cell in the column in which you wish to see the outcome (in this case, cell D6).
- Then. enter the formula as follows:
=C6+(8/24)
- To add 8 hours to the time in cell C6, press Enter to see the result.
- Next, to duplicate the formula down to the other cells in the range, double-click Fill Handle(+), a little square in the bottom-right corner of the cell (D7 to D12).
All done! Column D‘s formula will now extend the time in column C by 8 hours and display the result in each corresponding cell.
📄 Important Notes
🖊️
Make sure you format the time values correctly. To be understood as time values rather than merely numbers, time values in Excel should be structured as “Time”.
🖊️
If the result exceeds 24 hours, adding 8 hours to time values may have an impact on the date information. You may need to keep the date data in a separate column and combine it with the time value after the computation.
📝 Takeaways from This Article
📌
Firstly, we used basic arithmetic formula to add 8 hours to time in Excel.
📌
Next, we used TIME function and explained its uses to add hours.
📌
Again, TIMEVALUE function’s versatility was explained in the same context.
📌
Finally, we used VBA macro to construct a code to add hours to time in a range in Excel.
Conclusion
Therefore, it can be concluded that adding 8 hours to time in Excel is a basic and uncomplicated activity that can be carried out in a variety of ways. There is a solution for every sort of user, whether you choose formula, functions, or VBA code. Select the technique that best satisfies your requirements to begin handling time data like a pro! If you have any questions, feel free to comment below. I will try to answer them as soon as possible. Have fun using Excel, and you can visit Excelden.com for more tutorials. Thank You.