• Excel Book Excerpt

Excel Calculate with Time

This page created on Thursday, August 4, 2016 by Bill Jelen

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 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.

  1. Time calculations.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy