4 Ways to Add 8 Hours to Time in Excel

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.

Add 8 Hours to Time


📁 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)

arithmatic formula to add hours to time

  • To add 10 hours to the time in cell C6, press Enter to see the result.

arithmatic formula 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).

Fill Handle

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.

Add hours to time final result


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.

Dataset to Add 8 Hours to Time

Method 1

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)

Arithmetic formula

  • To add 8 hours to the time in cell C6, press Enter to see the result.

Formula result to add 8 hours to time

  • 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).

Double-clicking Fill Handle

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.

Method 1 final output

Method 2

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)

Applying TIME Function to add 8 hours to time

  • To add 8 hours to the time in cell C6, press Enter to see the result.

Formula result to add 8 hours to time

  • 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).

Double-clicking Fill Handle

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.

Method 1 final output

Method 3

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")

Applying TIMEVALUE Function to add 8 hours to time

  • To add 8 hours to the time in cell C6, press Enter to see the result.

Formula result to add 8 hours to time

  • 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).

Double-clicking Fill Handle

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.

Method 1 final output

Method 4

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.

Inserting Module to write code

  • 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

Code to add 8 hours to time

  • Finally, press F5 to execute the code.

Method 1 final output


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)

formula to add hours to date and time

  • To add 8 hours to the time in cell C6, press Enter to see the result.

formula output

  • 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).

Using Fill Handle

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.

Final output of date and time


📄 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.

(Visited 66 times, 1 visits today)
Hassan Shuvo

Hassan Shuvo

Hello, I am Mehedi Hassan Shuvo.I am an Engineering graduate from Bangladesh University of Engineering and Technology. I love reading Thriller books, watching Anime, and playing Cricket. I also love learning about new software. Excel is one of my favorite ones by far. My efforts will be worthwhile if I can utilize my expertise to assist anyone. If you find any faults in my writing please let me know.I will try to correct them as I am learning everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo