How to track time in Google Sheets

Trying to figure out how long it took to complete a task?

Use =DATEDIF(start_date, end_date, time_unit) calculate the amount of days, months, or years between two dates.

Different values you can use for `time_unit`

• "Y": the number of whole years between start_date and end_date.
• "M": the number of whole months between start_date and end_date.
• "D": the number of days between start_date and end_date.
• "MD": the number of days between start_date and end_date after subtracting whole months.
• "YM": the number of whole months between start_date and

Common Use Cases

• Get a TTFR (Time to First Reply) metric for your customer support team
• Figure out which part of your process needs optimizing
• Calculating an "average" time to completion for your tasks