Creating a Work place time sheet.
How can I make one cell keep adding once another cell reaches maximum of 8:00.
Im trying to calculate overtime in a seperate column after employees enter Start/Finish times from drop-down cells. |
Creating a Work place time sheet.
How can I make one cell keep adding once another cell reaches maximum of
8:00. Im trying to calculate overtime in a seperate column after employees enter Start/Finish times from drop-down cells. Assuming your hours are in H1, you can use a formula something like this to track the OT hours... =IF(H18,H1-8,"") You will have to adjust this (the 8) to account for how the hours are stored in H1; but conceptually, that is probably the approach you are looking for. Rick |
All times are GMT +1. The time now is 03:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com