📅 Topic hub · 4 tutorials
Sum hours over 24, overnight shifts, ages, working days and dates stored as text, in Excel and Google Sheets.
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.
Excel dates left-aligned, not sorting, or giving #VALUE!? Detect dates stored as text and convert them with DATEVALUE, Text to Columns, Paste Special or DATE+MID.
Calculate age from a date of birth in Google Sheets with DATEDIF: whole years, years-months-days, age on a set date, next birthday, plus leap-day and month-end edge cases.
Calculate hours worked in Excel when a shift crosses midnight. Copy the MOD formula, subtract breaks, total over 24 hours, split night hours and overtime. Free timesheet.