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.
Configuration: Windows XP Internet Explorer 6.0
Hi,
|
Create a date in excel form Create pop up message in excel Excel formula find text in cell Excel formula percentage one cell Excel formula that alters cell background color Excel formula to break cell contents into two cells Excel formula to find date between 2 ranges Excel formula to find different values in lists Excel percentge calculation formula Excel repeat formula in rows Excel sorting formula Excel vb column values copy "not formula" Formula for convert number to text in excel How to add a 1/2 in excel formula How to convert percentages for excel formula How to send the result of excel formula in other cell If total more than formula excel Macro create new document in excel