ads' corner

Convert Time Duration to Seconds in Google Sheets

When working with time duration (aka: time span) in Google Sheets, it is sometimes necessary to know how many seconds are elapsed. After all, '0:42:23'`' is not very handy to calculate with, and neither is '0*3600+42*60+23'. But '2543 seconds' is easy. This article explains how to do the calculation.