View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bunnyc
 
Posts: n/a
Default Multiplying time values and numbers


I have a spreadsheet that calculates regular hours and overtime hours. I
formatted my times [hh]:mm. What forula would I use to calculate total
pay. I tried A2*B2*24. A:hours worked and b:pay rate. This works okay
if there are no minutes involved (10:35). What formula would I use to
get the results I need?


--
bunnyc
------------------------------------------------------------------------
bunnyc's Profile: http://www.excelforum.com/member.php...o&userid=31662
View this thread: http://www.excelforum.com/showthread...hreadid=513521