calculating total payment - Time duration x Hourly Rate

**sobiafiaz** · 10-06-2007, 10:11 AM

I have created a spreadsheet about hours worked and payment. I cannot figure out how to work out if someone clocks in at 8:30 and clocks out and 5:30 and is payed £10 an hour..what will the total be? how would i set this up on excel and work it out?

much thanks

**VBA Noob** · 10-06-2007, 10:32 AM

Try

=(B2-A2+(A2>B2)*24)*10

VBA Noob

**nattasiray** · 10-06-2007, 10:35 AM

Calculate the duration time using this formula

Please Login or Register  to view this content.

Calculation the payment fee

Please Login or Register  to view this content.

Then Format cells using Number Format

Because the base unit of payment on hiring fee is base on Pound/day.

**sobiafiaz** · 10-06-2007, 05:24 PM

thank you very much!!

calculating total payment - Time duration x Hourly Rate

LinkBack

Thread Tools

Rate This Thread

Display

calculating total payment - Time duration x Hourly Rate

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions