Hi. I am making an Excel Spreadsheet that will keep my work times in it. Well at the end of each pay period, I have a row dedicated to totaling up my hours, and estimating the paycheck for that pay period. Though I am running into problems.

Since the total hours are in a “Time” format, simply multiplying the time against my hourly wage will give me an inaccurate number. That is where I go wrong. For example, the total time will read 23:25 (23 hours, 25 minutes). Multiplying that against an hourly pay (for example, $20) will give me the result $19.51 in Excel using =”SUM(G10*20.00)” where G10 is the cell with the total time.

I know I need a “base” but I don’t know how to calculate it in Excel. How do I tell it to only take the hours and multiply it against 60, add the minutes, divide it all by 60, and multiply it against the hourly wage?

Thank you in advance.