excel training courses uk - time calculation

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses uk - Time Calculation

excel training courses uk - Time Calculation

resolvedResolved · Low Priority · Version Standard

Michael has attended:
Excel Intermediate course
Excel Advanced course

Time Calculation

How can I enter hours and minutes in cells and then do calculations such as:

- summing cells to get total time in hours and minutes?
- dividing total time by a total quantity of units to get average time in hours and minutes per unit?

RE: 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.


 

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips


Server loaded in 0.1 secs.