software

I want to multiply hours and minutes worked by number of workers. Any
suggestions?--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: www.excelforum.com/member.php...oamp;userid=28426
View this thread: www.excelforum.com/showthread...hreadid=505894
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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=505894=A1*B1
Formatgt;Cellsgt;Numbergt;Custom, in the Type box, enter [h]:mm

--
Kind regards,

Niek Otten

quot;God's Kidquot; gt; wrote in
message ...
gt;
gt; I want to multiply hours and minutes worked by number of workers. Any
gt; suggestions?
gt;
gt;
gt; --
gt; God's Kid
gt; ------------------------------------------------------------------------
gt; God's Kid's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28426
gt; View this thread: www.excelforum.com/showthread...hreadid=505894
gt;

Thanks that did the trick

SteveG Wrote:
gt; Assuming you are usin hh:mm format and you want to convert the total to
gt; hours then if your time is in A1 say 11:28 and your number of employees
gt; is in A2.
gt;
gt; =HOUR(A1)*A2 ((MINUTE(A1)*A2)/60)
gt;
gt; This will return 57.3 hours for 5 employees.
gt;
gt; Does that help?
gt;
gt; Steve--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: www.excelforum.com/member.php...oamp;userid=28426
View this thread: www.excelforum.com/showthread...hreadid=505894