If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pulling numbers from hhh:mm:ss
I have a column of numbers in hhh:mm:ss and need to sum them per group,
when I try to add them its ugly the only way I've been able to do it correctly is pull the number out and copy them to a seperate column ie: hours mins secs then add them independantly then use the 24*60*60 to get them to come out right. question 1. is there an easier way to add these without trying to pull them out (the format on the cells are custom and hhh:mm:ss). 2. If I have to copy them over into seperate columns what is the best way to do it (automatically). As most of you know I'm not the code master so go easy on me please. Thanks for all help, ScottP |
#2
|
|||
|
|||
see if the info here helps you
http://cpearson.com/excel/datearith.htm "tri_p" wrote: I have a column of numbers in hhh:mm:ss and need to sum them per group, when I try to add them its ugly the only way I've been able to do it correctly is pull the number out and copy them to a seperate column ie: hours mins secs then add them independantly then use the 24*60*60 to get them to come out right. question 1. is there an easier way to add these without trying to pull them out (the format on the cells are custom and hhh:mm:ss). 2. If I have to copy them over into seperate columns what is the best way to do it (automatically). As most of you know I'm not the code master so go easy on me please. Thanks for all help, ScottP |
#3
|
|||
|
|||
Thanks Duke very much. I looked back and wrote a formula to "peel" off the
last 0 in the hhh and made it hh and excel liked that so the numbers calculated properly. "Duke Carey" wrote: see if the info here helps you http://cpearson.com/excel/datearith.htm "tri_p" wrote: I have a column of numbers in hhh:mm:ss and need to sum them per group, when I try to add them its ugly the only way I've been able to do it correctly is pull the number out and copy them to a seperate column ie: hours mins secs then add them independantly then use the 24*60*60 to get them to come out right. question 1. is there an easier way to add these without trying to pull them out (the format on the cells are custom and hhh:mm:ss). 2. If I have to copy them over into seperate columns what is the best way to do it (automatically). As most of you know I'm not the code master so go easy on me please. Thanks for all help, ScottP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to make excel not round real numbers when making a histogram? | Leedawg | Charts and Charting | 1 | September 21st, 2005 07:36 PM |
formulas to numbers | Steve | New Users | 2 | September 16th, 2005 12:07 AM |
Hightlighting Numbers & then all Cells to the right of these Numbers. | Dave | Worksheet Functions | 4 | August 29th, 2005 10:30 PM |
Count comma separated numbers, numbers in a range with dash, not t | Mahendra | General Discussion | 0 | August 8th, 2005 05:56 PM |
Searcing multiple numbers | Ken | General Discussion | 4 | November 6th, 2004 02:53 PM |