Summing time in Excel

When I hire someone to fill a short-term casual role here at Gravity Computing, I usually make up a simple timesheet in Excel.  I’ll use that to track start and end times, and to calculate how much they should be paid at the end of the week.  One wouldn’t think of this as any particularly advanced Excel formula – it should be pretty basic, right?  But Excel never does this the way I think it should:

More →