Calculate hourly rate by number of hours

N

nateg

Version: v.X
Operating System: Mac OS X 10.4 (Tiger)

C2 is time format Time In (8 am). D2 is time format Time Out (2 pm). E2 = D2-C2 (6 hr). I want F2 to = $50 * 6 hr = $300. I am using F2 = E2*50 and the result is $12.50
 
N

Niek Otten

Since time in Excel is stored as a fraction of a day (and a day is 1), you need to multiply by 24.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: v.X
| Operating System: Mac OS X 10.4 (Tiger)
|
| C2 is time format Time In (8 am). D2 is time format Time Out (2 pm). E2 = D2-C2 (6 hr). I want F2 to = $50 * 6 hr = $300. I am
using F2 = E2*50 and the result is $12.50
 

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.

Ask a Question

Similar Threads

Help with calculating time and a half - I've got straight time and double time. 4
Time Sheet - Calculating Time Differences for Totals 3
Calculate After hours 3
Payment calculation 1
Change Data Source in Chart 1
pieces picked per hour 0
trouble with calculating wages to hours worked 3
Multiply hours by dollars for timesheet or invoice 1

Top