Multiplying time by number
 

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


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=505894

Multiplying time by number
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505894

Multiplying time by number
 

=A1*B1
FormatCellsNumberCustom, in the Type box, enter [h]:mm

--
Kind regards,

Niek Otten

"God's Kid" wrote in
message ...

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


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile:
http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=505894

Multiplying time by number
 

Thanks that did the trick

SteveG Wrote:
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


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=505894