Calculating Billing, hours * rate

  • Thread starter Thread starter Tony Bender
  • Start date Start date
T

Tony Bender

Is there a way to calculate billing? I have a spread sheet with
column C for 'time in' and column D for 'time out' and column E for
the difference (hours worked). These columns are formatted as time.
Column F is the billing rate expressed as currency. I'm trying to
calculate the billing by multiplying the hours worked times the hourly
billing rate(Col E * Col F), but it's not working.

Can this calculation be done in Excel? If so, then how...

Thank you
 
Tony,

Times are stored as a fraction of a 24 hour day (6:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc), so you'll need to multiply the
time by 24 before multiplying by the hourly rate. E.g,

=hours*24*rate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You didn't say what is NOT working. You probably forgot that an hour is 1/24
of a day.
 
Back
Top