| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculations for Scheduled vs Actual Employee Time and Wages
I am THRYING to make a simple schedule worksheet for a manger to use to
calculate the time he schedules an employee to clock in and out and what it will cost him in regards to his allocated budget and then to be able to compare it after the job is completed. BUT time calculations have thrown me for loop and I am stuck for hours on trying to calculate time fields. PLEASE DEAR GOD can someone help me. Below is a simple example of my worksheet. A2 (Time IN) = 1:00 PM A3 (Time OUT) = 5:00 PM A4 (Time Worked) = 4:00 (h:mm format) Formula A3-A2 in This seems to be OK BUT when I then multiply the hours work by the hourly rate it does not work. A5 (Hourly rate) = $12.00 (Currency Format) A6 (Total Paid) = $2.00 WHEN IT SHOULD BE $48.00 I know it is calculating the dollar amount due based on .20 Time worked but for my life I cannot see how to make the changes necessary for this to work. The actual fields I am using in case it makes a difference a Employee Name (Drop List) Hutson, Gregg Pay Rate (Drop List) $12.00, $15.00 ect. Assigned Position (Drop List) such as bartender, carver, chef etc. Scheduled IN TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Actual IN TIME (Drop List) 12:00 PM, 12:30 PM ect Actual OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled Hours (h:mm) Actual Hours (h:mm) Difference (h:mm) Scheduled Pay Amount(currency) Actual Pay Amount (currency) Difference (currency) I am useing Excel 2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculations for Scheduled vs Actual Employee Time and Wages
No need to ask the same question 3 times. It has already been answered
twice. -- David Biddulph "The Caterer" wrote in message ... I am THRYING to make a simple schedule worksheet for a manger to use to calculate the time he schedules an employee to clock in and out and what it will cost him in regards to his allocated budget and then to be able to compare it after the job is completed. BUT time calculations have thrown me for loop and I am stuck for hours on trying to calculate time fields. PLEASE DEAR GOD can someone help me. Below is a simple example of my worksheet. A2 (Time IN) = 1:00 PM A3 (Time OUT) = 5:00 PM A4 (Time Worked) = 4:00 (h:mm format) Formula A3-A2 in This seems to be OK BUT when I then multiply the hours work by the hourly rate it does not work. A5 (Hourly rate) = $12.00 (Currency Format) A6 (Total Paid) = $2.00 WHEN IT SHOULD BE $48.00 I know it is calculating the dollar amount due based on .20 Time worked but for my life I cannot see how to make the changes necessary for this to work. The actual fields I am using in case it makes a difference a Employee Name (Drop List) Hutson, Gregg Pay Rate (Drop List) $12.00, $15.00 ect. Assigned Position (Drop List) such as bartender, carver, chef etc. Scheduled IN TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Actual IN TIME (Drop List) 12:00 PM, 12:30 PM ect Actual OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled Hours (h:mm) Actual Hours (h:mm) Difference (h:mm) Scheduled Pay Amount(currency) Actual Pay Amount (currency) Difference (currency) I am useing Excel 2007 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculations for Scheduled vs Actual Employee Time and Wa
Sorry about that I was getting error messages that said the the system was
busy and try again later, I refreshed my browser and waited and never saw it come up so I posted again. "David Biddulph" wrote: No need to ask the same question 3 times. It has already been answered twice. -- David Biddulph "The Caterer" wrote in message ... I am THRYING to make a simple schedule worksheet for a manger to use to calculate the time he schedules an employee to clock in and out and what it will cost him in regards to his allocated budget and then to be able to compare it after the job is completed. BUT time calculations have thrown me for loop and I am stuck for hours on trying to calculate time fields. PLEASE DEAR GOD can someone help me. Below is a simple example of my worksheet. A2 (Time IN) = 1:00 PM A3 (Time OUT) = 5:00 PM A4 (Time Worked) = 4:00 (h:mm format) Formula A3-A2 in This seems to be OK BUT when I then multiply the hours work by the hourly rate it does not work. A5 (Hourly rate) = $12.00 (Currency Format) A6 (Total Paid) = $2.00 WHEN IT SHOULD BE $48.00 I know it is calculating the dollar amount due based on .20 Time worked but for my life I cannot see how to make the changes necessary for this to work. The actual fields I am using in case it makes a difference a Employee Name (Drop List) Hutson, Gregg Pay Rate (Drop List) $12.00, $15.00 ect. Assigned Position (Drop List) such as bartender, carver, chef etc. Scheduled IN TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Actual IN TIME (Drop List) 12:00 PM, 12:30 PM ect Actual OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled Hours (h:mm) Actual Hours (h:mm) Difference (h:mm) Scheduled Pay Amount(currency) Actual Pay Amount (currency) Difference (currency) I am useing Excel 2007 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculations for Scheduled vs Actual Employee Time and Wages
See replies to your previous post. People are trying to help you, but you
have to meet them half-way: you need to read their replies. Regards, Fred. "The Caterer" wrote in message ... I am THRYING to make a simple schedule worksheet for a manger to use to calculate the time he schedules an employee to clock in and out and what it will cost him in regards to his allocated budget and then to be able to compare it after the job is completed. BUT time calculations have thrown me for loop and I am stuck for hours on trying to calculate time fields. PLEASE DEAR GOD can someone help me. Below is a simple example of my worksheet. A2 (Time IN) = 1:00 PM A3 (Time OUT) = 5:00 PM A4 (Time Worked) = 4:00 (h:mm format) Formula A3-A2 in This seems to be OK BUT when I then multiply the hours work by the hourly rate it does not work. A5 (Hourly rate) = $12.00 (Currency Format) A6 (Total Paid) = $2.00 WHEN IT SHOULD BE $48.00 I know it is calculating the dollar amount due based on .20 Time worked but for my life I cannot see how to make the changes necessary for this to work. The actual fields I am using in case it makes a difference a Employee Name (Drop List) Hutson, Gregg Pay Rate (Drop List) $12.00, $15.00 ect. Assigned Position (Drop List) such as bartender, carver, chef etc. Scheduled IN TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Actual IN TIME (Drop List) 12:00 PM, 12:30 PM ect Actual OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled Hours (h:mm) Actual Hours (h:mm) Difference (h:mm) Scheduled Pay Amount(currency) Actual Pay Amount (currency) Difference (currency) I am useing Excel 2007 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calculations for Scheduled vs Actual Employee Time and Wages
Hi,
Di your time calculation with this to convert to decimal. =(A3-A2)*24 If times could go over midnight use this =(A3-A2+(A3<A2))*24 Format as general and then multiply by the hourly rate Mike "The Caterer" wrote: I am THRYING to make a simple schedule worksheet for a manger to use to calculate the time he schedules an employee to clock in and out and what it will cost him in regards to his allocated budget and then to be able to compare it after the job is completed. BUT time calculations have thrown me for loop and I am stuck for hours on trying to calculate time fields. PLEASE DEAR GOD can someone help me. Below is a simple example of my worksheet. A2 (Time IN) = 1:00 PM A3 (Time OUT) = 5:00 PM A4 (Time Worked) = 4:00 (h:mm format) Formula A3-A2 in This seems to be OK BUT when I then multiply the hours work by the hourly rate it does not work. A5 (Hourly rate) = $12.00 (Currency Format) A6 (Total Paid) = $2.00 WHEN IT SHOULD BE $48.00 I know it is calculating the dollar amount due based on .20 Time worked but for my life I cannot see how to make the changes necessary for this to work. The actual fields I am using in case it makes a difference a Employee Name (Drop List) Hutson, Gregg Pay Rate (Drop List) $12.00, $15.00 ect. Assigned Position (Drop List) such as bartender, carver, chef etc. Scheduled IN TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Actual IN TIME (Drop List) 12:00 PM, 12:30 PM ect Actual OUT TIME (Drop List) 12:00 PM, 12:30 PM ect Scheduled Hours (h:mm) Actual Hours (h:mm) Difference (h:mm) Scheduled Pay Amount(currency) Actual Pay Amount (currency) Difference (currency) I am useing Excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Local Apparent Time (LAT) - real / actual solar time ? | Excel Worksheet Functions | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| How do I set up payroll for 1 full time and 1 part time employee? | New Users to Excel | |||
Hybrid Mode
