Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating with time
I have a worksheet to calculate wages. I enter the start time, finish time
and the pay rate. I need to get the wages payable which is a simple multiplication of hours and the pay rate. But when I do that calculation, I am getting the value based on time value x the pay rate, but not the actual value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field. Can someone help me how to get the actual value in wages field? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating with time
1 hour is 1/24th of a day so to change times into numbers multiply by 24:
(End Time - Start Time) * 24 * Wage Rate -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Satya Nanduri" <Satya wrote in message ... I have a worksheet to calculate wages. I enter the start time, finish time and the pay rate. I need to get the wages payable which is a simple multiplication of hours and the pay rate. But when I do that calculation, I am getting the value based on time value x the pay rate, but not the actual value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field. Can someone help me how to get the actual value in wages field? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating with time
For 8 hours x $20 = $160
="08:00:00"*24*20 or let A1 hold your hours worked and B1 hold your hourly wages: =TIME(A1,0,0)*24*B1 Thanks, Mike "Satya Nanduri" wrote: I have a worksheet to calculate wages. I enter the start time, finish time and the pay rate. I need to get the wages payable which is a simple multiplication of hours and the pay rate. But when I do that calculation, I am getting the value based on time value x the pay rate, but not the actual value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field. Can someone help me how to get the actual value in wages field? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating with time
Note that the latter formula will give an incorrect result if there are more
than 23 hours in A1. Besides since the time function takes an integer for each value it wont make much sense to first converting it to time and then converting back to decimals again? -- Regards, Peo Sjoblom "Michael Bowers" wrote in message ... For 8 hours x $20 = $160 ="08:00:00"*24*20 or let A1 hold your hours worked and B1 hold your hourly wages: =TIME(A1,0,0)*24*B1 Thanks, Mike "Satya Nanduri" wrote: I have a worksheet to calculate wages. I enter the start time, finish time and the pay rate. I need to get the wages payable which is a simple multiplication of hours and the pay rate. But when I do that calculation, I am getting the value based on time value x the pay rate, but not the actual value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field. Can someone help me how to get the actual value in wages field? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating with time
Thanks a lot Michael. That really helped me out. Have a great Day
Satya "Michael Bowers" wrote: For 8 hours x $20 = $160 ="08:00:00"*24*20 or let A1 hold your hours worked and B1 hold your hourly wages: =TIME(A1,0,0)*24*B1 Thanks, Mike "Satya Nanduri" wrote: I have a worksheet to calculate wages. I enter the start time, finish time and the pay rate. I need to get the wages payable which is a simple multiplication of hours and the pay rate. But when I do that calculation, I am getting the value based on time value x the pay rate, but not the actual value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field. Can someone help me how to get the actual value in wages field? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time without using time functions... | Excel Worksheet Functions | |||
Calculating time and negative time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |