Efficency calculation

Hi Kay,

Thanks for your question in STL's forum.

To answer your question I need a little more information.

Are the duration entries in Excel listed exactly as you mention in your question i.e. do you have a cell that contains the entry:
'45 minutes' or does it just say 45 or does it say 0.45

And are the entries for durations over one hour listed the same as you mention in your question? i.e. 1 hours 5 mins or is it listed as 1.05.

It would really help if you would send me a little sample of the data as it is actually stored in your spreadsheet. Once I have that I can answer your question

Kind regards

Ron Oldeboom
Learning and Development Consultant
STL Training
email: ron.oldeboom@stl-training.com

Hi Kay,

I am so sorry I gave you the wrong email address.
It was .co.uk instead of .com

so ron.oldeboom@stl-training.co.uk

My apologies.

If Jens already gave you the answer you are looking for would you do us a favour and mark the query as resolved?

If not you can send your file to the right email address

Again, sorry for the confusion

Ron Oldeboom