Does anyone have suggestions dealing with the Duration type and midnight? One of the apps we built includes duration fields to track hours worked, except if the shift ends at midnight, the 0:00:00 AM timestamp will throw the hours off. I realize why it’s doing it, but wondered if there was an easier way than having them clock out at 11:59 PM and adding 1 minute to the duration or multiplying by a negative 1 if clocking out at midnight.
An example shift would be 7-3:30 and that same person worked overtime from 3:30-Midnight on the same day. The app calculates -15 hours, which it should be 15 hours (two lunch period of a half hour are included in the calculations).