Google Sheets How-to
How to Sum Time Over 24 Hours in Google Sheets (Duration Format Fix)
Your time total resets after 24 hours? Format the SUM as a duration ([h]:mm) in Google Sheets, convert to decimal hours, handle overnight shifts and text times.