Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

Converting time

Posted by Paul Johnson on December 21, 2001 6:57 AM

I have two columns of data.
col 1 11/01/2001 01:00:00 AM
col 2 11/01/2001 05:22:00 AM

I need to find the difference (4:22:00) as a number to be used in a pivot table. When I convert the [h]:mm:ss formatted data to the pivot table it carries the AM/PM desginator. How do I fix this ?

Thx

Re: Converting time

Posted by Scott on December 21, 2001 9:03 AM

If you go into the pivot table wizard, and then doble click on the column header, you can format the column by selecting "number".

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.