Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Adding Time Hrs and Mins | Excel Discussion (Misc queries) | |||
Adding time | New Users to Excel | |||
Entering Times | Excel Discussion (Misc queries) | |||
adding in time formats | Excel Discussion (Misc queries) | |||
Adding time to multiple cells using TIMECODE | Excel Discussion (Misc queries) |