Cells C7:C11 are now filled with the succeeding times, with 30 minutes interval in between.įigure 11. Press F9 to trigger Excel to calculate and reveal the true values. Copying the formula and pasting to the other cells Cells C7:C11 will be filled with the same value as that of C6 which is “1:30:00 AM”.įigure 10. Entering the formula for the first time intervalįigure 9. This formula adds a constant value “0:30:00” or “30 minutes” to the previous cell.įigure 8. Note that we fix B5 by putting “$” sign before the column B and the row 5. Sample table for determining time intervals in Excel Set-up the data using a similar table as the previous example.įigure 7. Since there is a 30 minutes interval between the two, the other cells are also filled with 30 minutes interval Determine Time Intervals by Doing the Math Note : AutoFill based the filling of values on the first two cells we highlighted, C5 and C6. Output: Determine 30 minute time intervals using AutoFill Cells C7:C11 are now filled with the succeeding times, with 30 minutes interval in between.įigure 6. We can drag the cursor further down, depending on our desired data for time intervals.įigure 5. Moving the cursor to the bottom right corner for AutoFill Move the cursor to the bottom right corner to turn it into a solid cross.įigure 4. These two time intervals will be the pattern that AutoFill will use to fill the other cells with values. Entering the formula for the first time interval The result is 1:30:00 AM, which is the first 30-minute interval from the starting time of 1:00:00 AM.įigure 3. Sample table for determining time intervals using AutoFill in Excel Determine Time Intervals Using AutoFillĪutoFill is a feature in Excel that automatically fills cells with data, following a pattern or based on the values of other cells.
For this exercise, we will determine 30-minute time intervals. Final result: Determine 30 minute time intervals in Excel Setting up the DataĬreate the table below and indicate the time interval and starting time. This step by step tutorial will walk through the process used to determine time intervals in Excel.įigure 1. There are two simple ways to determine time intervals in Excel : we can either use AutoFill, or simply do the Math. Time intervals are particularly useful to us especially when we are monitoring or tracking something, in work or at home.
#30 minute time how to#
Learn How to Determine Time Intervals in Excel
0 kommentar(er)
