Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



Determining kg’s picked per hour in Microsoft Excel

If you have workers that work shifts and you are trying to determine how effective they are, you may use Excel to determine a ratio, for example, kilograms picked per hour. If you use Excel time format, a 24 hour day is represented in a fraction format e.g. 8 hours of work is shown in Excel as 0.33333 (8hrs/ 24 hrs) and you can format it to show as 8:00:00 . If you use this in a calculation though you will need to divide by 24 hours to get an appropriate number.

So if a worker picks 120 kg in 8 hours, the obvious answer is 15 kg per hour. If you simply divide the 2 cells in excel it will give you an answer of 360. Divide the 360 by 24 you get to the 15 you require.


Learn more at our live advanced Excel courses in South Africa. Visit Live Excel Training page