|
mixed text and formula results
I need to track the hours of part time employees to ensure that the average
number hours per week they work does not exceed 18. Calculating the average is easy enough but I would like the cell to display how many hours over the average they have worked. For example, if the employee worked 37 hours in two weeks the cell should say €śExceeded allotted hours by 1.00€ť. The formula so far is =IF(AVERAGE(B3:B16)18,"exceeds allowable hours by", AVERAGE(B3:B16)) Thank you |
mixed text and formula results
Change your fomula to:
=IF(AVERAGE(B3:B16)18,"exceeds allowable hours by "&(AVERAGE(B3:B16)-18)&" hours",AVERAGE(B3:B16)) -- Kevin Backmann "johnu" wrote: I need to track the hours of part time employees to ensure that the average number hours per week they work does not exceed 18. Calculating the average is easy enough but I would like the cell to display how many hours over the average they have worked. For example, if the employee worked 37 hours in two weeks the cell should say €śExceeded allotted hours by 1.00€ť. The formula so far is =IF(AVERAGE(B3:B16)18,"exceeds allowable hours by", AVERAGE(B3:B16)) Thank you |
| All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com