Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Convert hours and minutes to minutesPosted 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!
|Check out our Excel Resources
Re: Convert hours and minutes to minutesPosted by Barrie Davidson on August 28, 2001 10:44 AM
Assuming start time is in cell A1 and stop time is in cell B1, this formula will calculate total minutes.
Re: Convert hours and minutes to minutesPosted by IML on August 28, 2001 11:04 AM
Or, you could use
with a custom format of
Re: Convert hours and minutes to minutesPosted by Mark W. on August 28, 2001 11:31 AM
If cell A1 and B1 contain 8:32 and 9:54 respectively
the use the formula...
Rate per hourPosted by IML on August 28, 2001 11:33 AM
After a second read, lets say you still have start time in A1, stop time in B1 and quantity processed in C1
Your rate per hour should be:
with a general or number format. Excel stores time as fractions of days. Mark W. has been saying this forever and I'm just starting to believe him!
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.