#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wesley Accellent
 
Posts: n/a
Default Adding Time

I have a colum where the amount of time required to make a particular part is
listed in seconds (this is the result of a formula subratcting the start time
from the end time). I have a pivot table to add the total amount of each
type of part time and the total time required to make the parts. I can not
get the seconds and minutes to add up to realistic numbers.

How can I add minutes and seconds and get a usable number?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Adding Time

The pivot table may be working. First try formatting the pivot results as
[mm]:ss
--
Gary's Student


"Wesley Accellent" wrote:

I have a colum where the amount of time required to make a particular part is
listed in seconds (this is the result of a formula subratcting the start time
from the end time). I have a pivot table to add the total amount of each
type of part time and the total time required to make the parts. I can not
get the seconds and minutes to add up to realistic numbers.

How can I add minutes and seconds and get a usable number?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Adding Time Hrs and Mins Mike Busch Excel Discussion (Misc queries) 1 November 23rd 05 04:24 PM
Adding time trucker New Users to Excel 1 November 22nd 05 10:18 PM
Entering Times Denise Excel Discussion (Misc queries) 9 November 15th 05 04:57 PM
adding in time formats rvnwdr Excel Discussion (Misc queries) 1 May 31st 05 11:38 PM
Adding time to multiple cells using TIMECODE timroutledge Excel Discussion (Misc queries) 1 May 25th 05 06:24 PM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"