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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…