Forum Discussion
Time Sheet Formula Help
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 ...
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.
What would that look like? I'm unfamiliar with this function and couldn't find much help on google
