Easy Time Format

Easily format time periods and calculate sum and average in your Google Sheet!

Format Time Periods

  • Using days, hours, minutes, and seconds
  • Simply include "d", "h", "m", and "s" for each period
  • Use built-in custom functions to calculate
    • sum
    • average
    • max and min
  • Much easier to read than the built-in time durations 00:00:00.000
easy time formula 1

Split Using Conjunctions

  • And
  • Or
  • Comma
  • Semicolon
  • Single space
conjunctions demo