I have been trying to figure out a formula that will automaticially input a time value if an time if over 10:24 but only show the amount that is between 10:24 and 12:00. For example, I work 12hrs and 26 mins I want it to show the 1:36. When I work under 10:24 it is left blank and under 12 hours it will show only the time over the 10:24. attached is an example, Jun tab is the time worked and paysheet tab is where i want the formula to go starting in A2 going down.
IF formula help
- Thread starter Tman97
- Start date
Debraj, thanks so much! For the most part that appears to work, however is there a way to make it so that it will not post 0:00 in the rows that are less than 10:24? I would like to be able to glance at the worksheet and quickly see what days I worked overtime, which would be the days with a time in them. Also not wanting it to fill every row with 1:36 before data is entered on Jun tab. please review updated file to see what happens when I entered the formula.