i'm sure this has been asked more than once before but i've spent hours wading thru thousands of posts and search hasn't been any more helpful so thanks for understanding
what i need is a formula that will take the sum of start and end times then check if it is greater than 6 hours and if true will deduct a half hour from hours worked.
i also need it to display 0 hours worked if anything other than a start time is entered, like off, or paid day off etc
thanks very much in advance
Bookmarks