Average time between 2 dates

[Dom]

Hi

I am tryed to put together some formulas to work the average time taken for
this below information but i have got myself all muddled up and I bet the
solution is fairly straightforward I want to work out the average time
between the firstapproved date and the actual start date to work out the
average time taken to start all jobs logged. I would like the information in
hours I know it should be straight forward but my brain has gone a bit fried

A1 A2
FIRSTAPPROVED ACTSTART
09/11/2006 12:05 14/11/2006 11:35
17/11/2006 12:05 20/11/2006 10:20
01/12/2006 13:20 04/12/2006 17:16

Thank you very much

 

[Niek Otten]

In C1: =A2-A1, format custom as [h]:mm
Copy down as far as needed
Below all cells in C; =AVEARAGE(C1:C10) if C10 was the last one

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi
|
| I am tryed to put together some formulas to work the average time taken for
| this below information but i have got myself all muddled up and I bet the
| solution is fairly straightforward I want to work out the average time
| between the firstapproved date and the actual start date to work out the
| average time taken to start all jobs logged. I would like the information in
| hours I know it should be straight forward but my brain has gone a bit fried
|
| A1 A2
| FIRSTAPPROVED ACTSTART
| 09/11/2006 12:05 14/11/2006 11:35
| 17/11/2006 12:05 20/11/2006 10:20
| 01/12/2006 13:20 04/12/2006 17:16
|
| Thank you very much
|
|
|
|
|

 

[Niek Otten]

I messed up rows and columns, much like you did in your table layout!
For A2, read B1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In C1: =A2-A1, format custom as [h]:mm
| Copy down as far as needed
| Below all cells in C; =AVEARAGE(C1:C10) if C10 was the last one
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
|| Hi
||
|| I am tryed to put together some formulas to work the average time taken for
|| this below information but i have got myself all muddled up and I bet the
|| solution is fairly straightforward I want to work out the average time
|| between the firstapproved date and the actual start date to work out the
|| average time taken to start all jobs logged. I would like the information in
|| hours I know it should be straight forward but my brain has gone a bit fried
||
|| A1 A2
|| FIRSTAPPROVED ACTSTART
|| 09/11/2006 12:05 14/11/2006 11:35
|| 17/11/2006 12:05 20/11/2006 10:20
|| 01/12/2006 13:20 04/12/2006 17:16
||
|| Thank you very much
||
||
||
||
||
|
|