View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default 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