Convert hours and minutes to minutes
Posted by Laurie on August 28, 2001 10:38 AM
I am no expert in Excel formulas and after looking through as many plain language Excel books I can find, I beseech your help.
I have to keep count of how many accounts are input in the time recorded. From this input data I need it to show the input rate per hour.
I record the start time in cell 1, stop time in cell 2, count input in cell 3. Cell 4 is a formula =cell 2 - cell 1 to compute total time spent inputing. How can I make Cell 4 show the total time as minutes? (Example: Cell 1 = 8:32, Cell 2 = 9:54. Cell 4 = 1:22. I need Cell 4 to convert to the whole number 82) Once I have that whole number I can write a formula for cell 5 such as =cell 3/(cell 4/60) to show the input rate per hour. If Cell 3= 134 then this would result in a input rate of 98 per hour =134/(82/60).
Thank you for your help!