Multiplying time by number

G

God's Kid

I want to multiply hours and minutes worked by number of workers. Any
suggestions?
 
S

SteveG

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
 
G

God's Kid

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...
 
Top