Enter a positive number to add to the date or a negative number to subtract from it. How to Add or Subtract Days from Dates in ExcelĪssuming that you have the original dates to work with, enter the number of days that you want to add or subtract from the dates in that adjustment column. RELATED: How to Convert Text to Date Values in Microsoft Excelįor this example, we’re using due dates, and we have the columns set up in the order described above: Due Date, Adjustment, and New Due Date. Also, make sure that the date columns are formatted for dates in whichever style you prefer. A column to enter the number of days that you want to add or subtract.ĭepending on which data you already have in your sheet, the first step is to make sure that you have these columns.A column with the original dates (deadlines, due dates).For PC instructions, click here.Ĭlick here to watch this video on YouTube.You’ll need three columns in your sheet to accommodate the date adjustments. Note: The instructions and video tutorial are for Macs. The answer is displayed as an AM time, so to change that, right click and select Format Cells and change it to h:mm. It’ll return the answer in time format (7:35, or 7 hours and 35 minutes). To subtract time, type in =B2-B1, and it’ll return the elapsed time.Type 9:15:00 AM into cell B1, and type 4:50:15 PM into cell B2.Here, we’re using seconds, but you can also round if you prefer. She arrives at 9:15:00 AM and leaves at 4:50:15 PM. Let’s say you’d like to calculate how many hours an employee worked, using her clock-in/clock-out times on her timecard. Subtracting time (calculating elapsed time)

To add time, type in =A1+A2, and it’ll return the answer in time format (13:15, or 13 hours and 15 minutes).Type 7:30 into cell A1, and type 5:45 into cell A2.The first task will take 7 hours and 30 minutes, and the second will take 5 hours and 45 minutes. Let’s say you’d like to know how many hours and minutes it’ll take to complete two tasks. Type in :mm so that the data displays in an hour:minute format. First, you’ll format the cells for time calculations.Whether you’re adding up employee timesheets, or doing calculations regarding the use of your team’s time on a project, knowing how to do calculations with time in Excel is something everyone in a business environment should know how to do.

Adding and subtracting units of time in Excel can be a useful thing to know how to do.

Formula for subtracting in excel