Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
CatherineMaddenBrass ContributorMay 26, 2023Time Calculation How do I get the hours worked to not be negative numbers and to be correct? They are employees that work a 10 (3p-1a) or 12 hour (3p-3a) shift. Their shift starts "today" and ends "tomorrow". ...Show More
Riny_van_EekelenPlatinum ContributorMay 26, 2023CatherineMadden Like so:Works also for times from 3 PM to 11 PM.
CatherineMaddenBrass Contributor to Riny_van_EekelenMay 26, 2023Riny_van_Eekelen When I used that formula, this is what I got:
