# calculate payment due based on hours worked

#### diverdave

##### Board Regular
I have the following:

Column A=date (format is: Date 3/14/01)
Column B = start time (format is: "Custom h:mm")
Column C = end time (format is: "Custom h:mm")
Column D = total hours (format is: "Custom h:mm")
Column E = wages due (format is: "Currency (\$1,234.10) )

In column E I want to return the value in dollars for wages due by multiplying the total hours worked in column D by an hourly wage
i.e. 3.5 hours X \$20.00 per hour = \$70.00 wages due.

Date = 1/1/05 / Start time = 8:00 / End time = 16:00 / Total Hours = 8.00 / Total \$ due = \$160.00

I would appreciate help with the formula to accomplish this.

Thanks, Dave

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Assuming that D3 contains the total hours:

=+D3*24*20

Great!

Thanks pactps - that works perfectly.

I can't quite grasp the logic of how the conversion is being done though. If you care to take the time to explain it I'd appreciate it.

Either way, thanks for the help.
Dave

You may want to incorporate another column ("wage") in column E, moving "wages due" to column F, then use formulas as follows:

in D1, (Hrs Worked) =IF(C1<B1,(C1-B1)*24+24,(C1-B1)*24)
in F1, (Wages Due) =D1*E1

Formatting of cells is as follows...

A1 - Date
B1 - Time (1:30 PM)
C1 - Time (1:30 PM)
D1 & E1 - General
F1 - Currency

When entering times into B1 and/or C1, you must enter them as "15:00" for 3 pm, "9:00" for 9 am, "23:00" for 11 pm, etc

The Excel help contains a good explanation, but this could help:

Times in Excel are really numbers between 0 and 1.

To convert to hours, multiply by 24
Minutes - multiply by 1440 (ie 60 * 24)
Seconds - multiply byb 86400 (60 * 60 * 24)

tactps- thanks

Got it - Thanks,
Dave

Replies
1
Views
256
Replies
0
Views
215
Replies
3
Views
386
Replies
3
Views
232
Replies
5
Views
403

1,203,760
Messages
6,057,202
Members
444,913
Latest member
ILGSE

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back