Note: In the formula, A2 contains the date/time field, 12 is the hours you need to add to the date/time field. Select a blank cell says cell C2, enter formula =A2+12/24 into the formula bar, and then press the Enter key. If you want to add 12 hours to a date/time field as below screenshot, you can apply the following formula.ġ. ![]() You can apply the following formulas to add or subtract hours from a date/time field in Excel. Please do as follows.Īdd or subtract hours from a date/time field with formulasĪdd or subtract hours from a date/time field with Kutools for Excel ![]() This article aims to show you methods of adding or subtracting hours from a date/time field in Excel. How to add or subtract hours from a date/time field in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |