Back 
CPASelfStudy.com		  
     
  Time in Excel- Formatting Time:

If you add up a series of hours and minutes, Excel will not display the correct answer until you format the number into an hh:mm format. 

In Excel 2003

  1. Go to Format>Cells>Custom
  2. Find and select [h]:mm:ss.

In Excel 2007

  1. Click on the Home menu
  2. Click Format on the Cell tab
  3. Select Format cells>Custom
  4. Find and select [h]:m:ss.
  

 

Back 
CPASelfStudy.com