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.

Improve this question

2 Answers 2

Reset to default
2

You could also use:

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

Improve this answer
2
  • 1
    On a scale of zero to elegant I'd rate this tidy-ish.
    – AdamL
    Sep 20, 2014 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, 2014 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

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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