Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Time Difference
I have a deadline time entered as 10:11 in B7. In c7 through s7 I have the actual times, i.e. 10:06. In most instances the deadline was met, but in a few it was not. I'd like to have the average time variance between the deadline and the actual. I'm not very sophisticated in formulas, so my way would probably involve a string that's far too long. Is there a simple way to do this? Thanks, Jon -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=560826 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Time Difference
Jonhunt --
Simple approach, not very elegant: Cell C8: =$b$7-c7 Then copy from C8 out to S8. Cell T8: =VARP(C8:S8) HTH "jonhunt" wrote: I have a deadline time entered as 10:11 in B7. In c7 through s7 I have the actual times, i.e. 10:06. In most instances the deadline was met, but in a few it was not. I'd like to have the average time variance between the deadline and the actual. I'm not very sophisticated in formulas, so my way would probably involve a string that's far too long. Is there a simple way to do this? Thanks, Jon -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=560826 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Time Difference
Jon,
Not clear whether over and under are treated the same or not, but try this =AVERAGE(IF(C7:S7<"",ABS(B7-C7:S7))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jonhunt" wrote in message ... I have a deadline time entered as 10:11 in B7. In c7 through s7 I have the actual times, i.e. 10:06. In most instances the deadline was met, but in a few it was not. I'd like to have the average time variance between the deadline and the actual. I'm not very sophisticated in formulas, so my way would probably involve a string that's far too long. Is there a simple way to do this? Thanks, Jon -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=560826 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Time Difference
I couldn't get either of these to work, but I did take the $b$7-c7 and copy it out and then just averaged the results. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=560826 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Time Difference
I'll bet you didn't array enter it.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jonhunt" wrote in message ... I couldn't get either of these to work, but I did take the $b$7-c7 and copy it out and then just averaged the results. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=560826 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
Average Time Format | Excel Discussion (Misc queries) | |||
How do you calculate average time? | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |