calculating wages by hours and minutes

0

1. if truck is for a day ( per 8 hours) rs 3700/- then what will be the rate for 9 hours 15 minutes and 9 hours 25 minutes.

2. if truck is for a day ( per hour) rs 3700/- then what will be the rate for 9 hours 15 minutes and 9 hours 25 minutes.

Answer
Discuss

Answers

0

Create a test sheet as follows.

  1. Time out (column B)
  2. Time in (column C)
  3. Hours (Column D)
  4. Rate (column E)
  5. Charge (column F)

Enter times out and in in row 2, columns B:C, making sure that Excel understands your entries as times (usually a format like 13:45 will be understood, but you might also use 1:45 PM, depending upon your regional settings and your preference as expressed in the cells' format). Enter the 8-hour rate in E2, and these two formulas in D2 and F2 respectively.

=$C2-$B2
=($E2/8)*($D2*24)

This is a very rough schema which may need refining. For example, you will require another formula if you rent from one day to the next and Date/Time entries if you rent for more than 24 hours. Likely, you will also want to do some kind of rounding, such as charge every 5 minutes which were started or every completed block of 5 minutes.

The first hurdle to take is to be sure that you enter actual times. It is possible (easily!) in Excel to enter strings which look like times but represent letters instead of numbers. Letters can't be used in calculations, numbers can.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login