Google Sheets – Calculate Time Values in a Single Cell

google sheets

Is there a way to add two times, or durations, in one line in a Google Spreadsheet?

Something like:

=1:14:25+0:17:12 

I know that I can use the time command in-line, and that I can add times from two separate cells, but I was wondering if there was a simpler and more elegant way to add two times when entering them in the same cell.

Best Answer

You could also use:

="1:14:25"+"0:17:12"