Excel working out average Time

  Durko 16:45 04 Nov 05
Locked

In Excel how do I use the Time function (think this is the one) to calculate the overall average time in hours when presented with two lengthy columns of Time data?

e.g column B1= 10:00am is Start Time and C1= 10:42am is Finish Time, then B2= 10:45am and C2= 11:30am etc etc...

Advice greatly appreciated.

Durko

  VoG II 16:50 04 Nov 05

In D1 enter the formula

=C1-B1

and copy the formula down.

To calculate the average use

=AVERAGE(D1:D100)

Substitute the last used cell in D for D100 in the above.

  Durko 17:04 04 Nov 05

VOG

Advice much appreciated.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017