Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
improvement formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Improvement formula

Improvement formula

ResolvedVersion 2016

Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course

Improvement formula

Hi

I currently have the dataset below

The purpose of the data is to show whether the efficiency is improving over the weeks.

Please can you help me understand if there is a mathematical formula I can use to show this?

Week 1: 10 bottles took 01.00 to load
Week 2 18 bottles took 01:25 to load
Week 3: 9 bottles 00.45 to load
Week 4: 5 bottles 00:15 to load
Week 5: 20 bottles took 01:30 to load

Time is expressed in hh:mm format.

Thanks

RE: Improvement formula

Hi Kay,

Thank you for the forum question.

Please find attached Excel file.

You will need to calculate the trend over time or visualise the trend in a chart.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

bottles.xlsx

Excel tip:

Paste functions box quickly

If you want to do a formula using the paste functions box press SHIFT + F3.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.