Back to Forms in Excel VBA archive index

Back to archive home

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!

Laurie

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!

Laurie

Check out our Excel Resources | ||||

Assuming start time is in cell A1 and stop time is in cell B1, this formula will calculate total minutes.

=HOUR(B1-A1)*60+MINUTE(B1-A1)

Regards,

Barrie

Or, you could use

=B1-A1

with a custom format of

[m]

good luck...

If cell A1 and B1 contain 8:32 and 9:54 respectively

the use the formula...

the use the formula...

=(B1-A1)*1440

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:

=C1/(B1-A1)/24

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.

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.