Google Sheets: Show Elapsed Time

Jul 25, 2019

Calculate time difference

=NOW()-DATEVALUE("2019-07-01")

Formatting: Format -> Duraion.

  • 0:00:30 - 30 seconds ago
  • 0:40:30 - 40 minutes 30 seconds ago
  • 1:40:30 - 1 hour 40 minutes 30 seconds ago
  • 25:40:30 - 1 day 1 hour 40 minutes 30 seconds ago

NOTE: Alternative solution includes DATEDIF - Calculates the number of days, months, or years between two dates.

To enable auto refresh of elapsed time, goto File -> Spreadsheet settings -> Calculation -> Recalculate -> On change and every minutes.

❀️ Is this article helpful?

Buy me a coffee β˜• or support my work via PayPal to keep this space πŸ–– and ad-free.

Do send some πŸ’– to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

πŸ‘Ά Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.