Unless you know the start and end times will always exceed 24 hours, you
would need to include the date as well
A1: 9/25/2006 08:00 AM
A2: 9/26/2006 10:50 AM
A3: =(A2-A1)*24*B1
B1: $25.50 'hourly rate
Format A3 as currency or number (it will probably default to date).
if the end time will always be after the start time and exceed 24 hours
A1: 08:00 AM
A2: 10:50 AM
A3: =(A2-A1+1)*24*B1
B1: $25.50 'hourly rate
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.