# Adding Hours, Minutes, or Seconds to a Date and Time in Excel

This post will guide you how to add hours, minutes, or seconds to a given date and time in a cell in Excel. How do I add hours, minutes or seconds to a time with a formula in Excel. How to add hours to a date and time in Excel. How do I add 15 minutes to a time in excel.

## 1. Adding Hours to a Date and Time using Formula

If you want to add 2 hours to a specific date and time in one cell, you can use the following formula to achieve the result.

``=B1+ 2/24 ``

You need to type this formula into a blank cell and then press Enter key in your keyboard, and drag the AutoFill Handle over other cells to apply this formula to add 2 hours for other dates.

This formula will return a serial number, so you need to format the serial number as the standard date and time format.

## 2. Adding Hours to a Date and Time using VBA Code

If you want to use a more dynamic and programmable solution, VBA code is here to assist.

Open the VBA editor by pressing Alt + F11.

In the VBA editor, right-click in the Project Explorer, select Insert, and choose Module to create a new module.

Copy and paste the provided VBA code into the module.

``````Function AddHoursToDateTime(dateTimeCell As Range, hoursToAdd As Double) As Date
End Function
``````

This code defines a custom function AddHoursToDateTime to add hours to a date and time.

Type this formula in a black cell:

``=AddHoursToDateTime(B1, 2)``

Adjust the reference (B1 in this example) and the hours as needed.

## 3. Adding Minutes to a Date and Time using formula

If you want to add 15 minutes to a date and time in one cell, you can use the following formula:

``=B1 + 15/1440``

## 4. Adding Minutes to a Date and Time using VBA Code

For those seeking a more dynamic and automated approach, let’s explore VBA code for adding minutes.

Open the VBA editor by pressing Alt + F11.

In the VBA editor, right-click in the Project Explorer, select Insert, and choose Module to create a new module.

Copy and paste the provided VBA code into the module.

``````Function AddMinutesToDateTime(dateTimeCell As Range, minutesToAdd As Double) As Date
End Function
``````

This code defines a custom function AddMinutesToDateTime to add minutes to a date and time.

Return to your Excel sheet and leverage the custom function, in one black cell type this formula:

``=AddMinutesToDateTime(A1, 30)``

Adjust the reference (A1 in this example) and the minutes as needed.

## 5. Adding Seconds to a Date and Time using formula

If you want to add 1 second to a date and time in one cell, you can use the following formula:

``=B1 + 1/18640``

You can also create another formula based on the TIME function to achieve the same result.
For example, you want to add 2 hours, 15 minutes, 1 second to a data and time value in Cell B1, you can use the following formula:

``=B1 + TIME(2,15,1)``

## 6. Adding Seconds to a Date and Time using VBA Code

For those who crave dynamic control over their time-related tasks, VBA code provides the necessary flexibility.

Open the VBA editor by pressing Alt + F11.

In the VBA editor, right-click in the Project Explorer, select Insert, and choose Module to create a new module.

Copy and paste the provided VBA code into the module.

``````Function AddSecondsToDateTime(dateTime As Date, seconds As Integer) As Date
AddSecondsToDateTime = dateTime + TimeValue("00:00:" & seconds)
End Function
``````

This code defines a custom function AddSecondsToDateTime to add seconds to a date and time.

``=AddSecondsToDateTime(A1, 45)``