Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding/Averaging Times in Excel
I'm trying to work with time. I'll be adding and averaging many different
process times for a business project. How do I format these times and write a formula. The tricky part is the times are all the way to milliseconds. The format is 00:00:00:00 in hh:mm:ss:ms. Say I have 00:05:55:78 and 00:04:34:98. How do I add these and then also get an average of the two?? I've been stuck with this problem for a while. Version 2003 Excel. |
#2
|
|||
|
|||
Are you sure you're last digits are milliseconds (thousandths a second)
or are they hundredths of a second? If the latter: B1: =LEFT(A1,8)+LEFT(A2,8)+(RIGHT(A1,2)+RIGHT(A2,2))/8640000 if you format the result as hh:mm:ss.00 will return 00:10:30.76. The average: B2: =B1/2 In article , "JD" wrote: I'm trying to work with time. I'll be adding and averaging many different process times for a business project. How do I format these times and write a formula. The tricky part is the times are all the way to milliseconds. The format is 00:00:00:00 in hh:mm:ss:ms. Say I have 00:05:55:78 and 00:04:34:98. How do I add these and then also get an average of the two?? I've been stuck with this problem for a while. Version 2003 Excel. |
#3
|
|||
|
|||
Thanks--one more thing. If I am adding more times in, how do I drag the
formula to include the new cells. I tried it, and it just keeps two cells instead of adding the third one. I don't want to have to type in ...Left A1,A2,A3, etc. for every new cell. Sorry I'm a novice. "JE McGimpsey" wrote: Are you sure you're last digits are milliseconds (thousandths a second) or are they hundredths of a second? If the latter: B1: =LEFT(A1,8)+LEFT(A2,8)+(RIGHT(A1,2)+RIGHT(A2,2))/8640000 if you format the result as hh:mm:ss.00 will return 00:10:30.76. The average: B2: =B1/2 In article , "JD" wrote: I'm trying to work with time. I'll be adding and averaging many different process times for a business project. How do I format these times and write a formula. The tricky part is the times are all the way to milliseconds. The format is 00:00:00:00 in hh:mm:ss:ms. Say I have 00:05:55:78 and 00:04:34:98. How do I add these and then also get an average of the two?? I've been stuck with this problem for a while. Version 2003 Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |