1

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.

2

You could also use:

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

  • 1
    On a scale of zero to elegant I'd rate this tidy-ish. – AdamL Sep 20 '14 at 19:53
  • 2
    Thanks, AdamL, that's what I was looking for! I actually tried this before, but it didn't occur to me that I then need to change the cell's format to "Time" to get the output in hh:mm:ss, rather than just a number... – gandi2223 Sep 21 '14 at 11:33
2

With the TIMEVALUE formula, you're able to make time based calculations within a cell.

Formula

=TIMEVALUE("01:00") + TIMEVALUE("02:15")

Screenshot

enter image description here

Example

I've created an example file for you: TIMEVALUE

Reference

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.