- Excel Book Excerpt
Excel Calculate with Time
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Calculate with Time
Problem: I need to do calculations by hour.
Strategy: There are functions HOUR, MINUTE, and SECOND to break a time into components. There is a function TIME(Hour,Minute,Second) to put time back together.
Figure 573 Time calculations.
For more resources for Microsoft Excel: