![]() In a perfect world she'd work in one queue for 6-2:30pm and a simple formula would work to get 7.5 hours but that's not the case. I have to record those times in each queue but at the end of the day her hours should not be more than 7.5. The problem is some days she works in as many as 8 different queues. At the end of the day she has 7.5 hours of productivity. ![]() She takes a 30 minute lunch and has two paid 15 minute breaks. I have an employee that works from 6:00am to 2:30pm. I've been trying to increase my knowledge of excel but I can't seem to find how to create this formula. which will work for any possible decimal value between the boundary points. Taking this to the extreme, one could easily define a constant that equals the smallest positive value that Excel can represent: ![]() of course those constants could/should be replaced by defined names. ![]() Again this is totally up to the user he can use whatever value he wants instead of the integers of one: However, I have used it with finer precision, hours, minutes, seconds. I have used this technique for years with operations scheduling and task management, often with a precision of days. When using the method I shared above to exclude the boundary points, the user is responsible for the precision. You bring up a good point that I should have clarified.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |