Apr 02 2020 01:05 PM
I have attached my time card (I work for my mum) and am having some problems with the Total Hrs (Hours) & Pay formulas. Please direct your attention to those two columns on the 2nd week (starting March 31) of the worksheet.
This should be obvious, but, for example, on C15 I clocked in at 10:30 AM, and am currently on the clock writing this (ahaha). Therefore, F15 is showing '######', and H15 is showing $-158 for today.
PLEASE HELP! This is driving me absolutely insane and have never felt the need to reach out to a forum like this before. I always figure this kind of thing out. Thanks so much in advance for taking the time to look at this!!!
Apr 02 2020 01:38 PM - edited Apr 02 2020 01:39 PM
Switch the test to Time_Out (column D) rather than Time_In. The test can be 'not blank' as you have it or you can test for a positive number since that is how times after midnight are represented. That should prevent the formula from calculating negative durations for the hours worked.
Apr 02 2020 05:01 PM
What would that look like? I'm unfamiliar with this function and couldn't find much help on google