11:30am | search
Click here to view 11:30am news from 60+ newspapers.
Bookmark or Share- Calculate the difference between two times - Microsoft SupportThere are several ways to calculate the difference between two times. Present the result in the standard time format. There are two approaches that you can take to present the results in the standard time format (hours : minutes : seconds).
- Add or subtract time - Microsoft SupportFollow these steps to get the elapsed time—which is the difference between two times. In cell B2, enter the start time and include “ a ” for AM or “ p ” for PM, and then press Enter. In cell C2, enter the end time, including “ a ” or “ p ” as appropriate, and then press Enter.
- Format numbers as dates or times - Microsoft SupportCreate a custom date or time format. On the Home tab, click the Dialog Box Launcher next to Number. You can also press CTRL+1 to open the Format Cells dialog box. In the Category box, click Date or Time, and then choose the number format that is closest in style to the one you want to create.
More
