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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…