Multiplying time by number

  • Thread starter Thread starter God's Kid
  • Start date Start date
G

God's Kid

I want to multiply hours and minutes worked by number of workers. Any
suggestions?
 
Assuming you are usin hh:mm format and you want to convert the total to
hours then if your time is in A1 say 11:28 and your number of employees
is in A2.

=HOUR(A1)*A2+((MINUTE(A1)*A2)/60)

This will return 57.3 hours for 5 employees.

Does that help?

Steve
 
Thanks that did the trick
Assuming you are usin hh:mm format and you want to convert the total t
hours then if your time is in A1 say 11:28 and your number of employee
is in A2.

=HOUR(A1)*A2+((MINUTE(A1)*A2)/60)

This will return 57.3 hours for 5 employees.

Does that help?

Stev
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate total for rate times hours in Excel? 3
Currency & hours 1
day:hour:minute:second format 1
Convert Time to Number 1
Font color dipicts which formula to use 2
Column multiplied by a matrix 2
Conditional Formatting 2
How to multiply time by monitary value 1

Back
Top