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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

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

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…