excel training courses uk - Time Calculation

Hi Michael, Thank you for your post, to answer your question, if you enter the time in the cells in the format hh:mm and then in your cell to obtain the information you woudl use either the formula =cell ref - (minus) cell ref, this will return a number, if you then format the cell to the time fomat hh:mm using a custom format, this will return the difference as a time.
Another method which will return either hours or minutes, use the =INT() function and by changing the extension as required get hour or minute difference for example; =int((cell ref - cell ref)*24) for hours, *1440 for minutes, you can then total or average the answer cells as required, formatting the result as a time should then give you your answers. I hope that helps, regards Pete.