Calculating Billing, hours * rate

[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

 

[Ron de Bruin]

Hi Tony

See this page
http://www.cpearson.com/excel/overtime.htm

And the topic page
http://www.cpearson.com/excel/topic.htm

 

[Chip Pearson]

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

 

[Don Guillett]

You didn't say what is NOT working. You probably forgot that an hour is 1/24
of a day.