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?