Add or Subtract Time - Prairie State College
Excel 2016: Add or Subtract Time
Add or Subtract Time
In Excel 2016, you can find the total time between a start and end time using Excel¡¯s formulas.
To Add Time
1.
2.
3.
4.
Select the cell where the total time will be displayed.
Then select the two cells with the start and end times.
Select AutoSum on the Home tab.
If the time is greater than 24 hours, adjust the formatting as follows:
a. Select the cell with the total time.
b. Right-click the cell and select Format Cell.
c. Select Custom.
d. In the Type field enter [h]:mm.
Note: The square brackets tell Excel to exceed 24 hours.
To Subtract Time
1. Select the cell where the total time will be displayed.
2. In the Formula bar, enter the formula:
=(first cell reference ¨C second cell reference)*24
3. Press Enter on the keyboard and the time will be displayed in the cell.
Note: Excel does not support a negative number formatted as time.
Updated: 4/16
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- working with dates and times stata
- excel spreadsheet subtract columns
- excel formulas cheat sheet skokie public library
- using date and date time in formulas salesforce
- using date and date time in formulas salesforce implementation guides
- excel date and time math university of florida
- 068 29 dating sas and ms excel
- ultimate suite for excel comprehensive set of time saving tools
- excel formulas bible e for excel
- excel add or subtract hours minutes seconds years months and days
Related searches
- how to add and subtract sig figs
- how to add and subtract radicals
- how do you add and subtract integers
- date calculator add and subtract days
- date calculator add and subtract dates
- add or subtract fractions calculator
- how to add and subtract significant figures
- add and subtract calculator online
- add or subtract percent calculator
- add and subtract mixed time units calculator
- add subtract time calculator
- how to add and subtract time excel