I run payroll for a small business.  I currently have a spreadsheet that totals hours and multiplies by the wage to give me a gross amount for each pay period.  I would like to be able to enter times: 8:30 to 20:30 and have excel calculate how many hours were worked.  Not only that, but in our business, anything over 8 hours is overtime, so I want to split it to 8 and 4.  I've tried subtracting time, but can't convert the h:mm format to an integer.

---

Answer from Richard Rost:

This tutorial covers calculating overtime pay:

http://599cd.com/tips/excel/overtime/?key=BlFAlEx

I have other tutorials which explain adding/subtracting dates and times:

There are many different techniques in Excel you can use to break apart dates or times into their component parts, add or subtract dates, and figure out how much time is elapsed between two dates.

Read this free tutorial from my web site that explains how to work with adding dates and times in Excel:

http://599cd.com/tips/excel/adding-dates-times/?key=BlFAlEx

I also have this FREE video tutorial that shows you how to get month names (like "September") from dates:

http://599cd.com/tips/excel/month-names/?key=BlFAlEx

I spend a LOT of time talking about dates and times in my full Excel tutorials:

http://599cd.com/Excel?key=BlFAlEx