I need help creating an Excel formula
Closed
Coop
-
Mar 12, 2009 at 01:33 PM
bauduco Posts 15 Registration date Thursday September 4, 2008 Status Member Last seen June 10, 2009 - Mar 13, 2009 at 04:30 AM
bauduco Posts 15 Registration date Thursday September 4, 2008 Status Member Last seen June 10, 2009 - Mar 13, 2009 at 04:30 AM
Hello,
I work in Human Resources and need to create a formula for Personal Time Off. The employees accure PTO time at the rate of 0.46 per regular hours worked, but, not to exceed over 80 hours. The colums in the spreedsheet are as follows:
A B C D E
Name Total Hours worked # of Hours x .046 Hours Minutes
how can I create a formula where cell bX.046 = ----hours and ----- minutes but not to exceed 80 hours.
Thanks for your help.
I work in Human Resources and need to create a formula for Personal Time Off. The employees accure PTO time at the rate of 0.46 per regular hours worked, but, not to exceed over 80 hours. The colums in the spreedsheet are as follows:
A B C D E
Name Total Hours worked # of Hours x .046 Hours Minutes
how can I create a formula where cell bX.046 = ----hours and ----- minutes but not to exceed 80 hours.
Thanks for your help.
Related:
- I need help creating an Excel formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
bauduco
Posts
15
Registration date
Thursday September 4, 2008
Status
Member
Last seen
June 10, 2009
8
Mar 13, 2009 at 04:30 AM
Mar 13, 2009 at 04:30 AM
hi,
try this link to get a book where you can find the formula you are searching for:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1
try this link to get a book where you can find the formula you are searching for:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1