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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
calculating wages by hours and minutes
0
Answers
0
Create a test sheet as follows.
- Time out (column B)
- Time in (column C)
- Hours (Column D)
- Rate (column E)
- 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.