Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 10 characters in body; edited tags
user0
• 23.8k
• 8
• 42
• 69

`````` Start time   |    End Time   |  Time difference
-------------+---------------+-----------------
11:30:00 |    12:45:00   |     1,25
-------------+---------------+-----------------
09:20:00 |    10:30:00   |
11:35:00 |    12:00:00   |    #VALUE!
-------------+---------------+-----------------
``````

In the 3rd column, I have a formula that calculates the difference in decimal number. 1st 1st row works, - can I make it work with the 2nd row without splitting the cell?

This is the error I get when I hover over #VALUE: Error Function MINUS parameter 1 expects number values. But '10:30:00 12:00`#VALUE`:00' is a text and cannot be coerced to a number.

Error Function MINUS parameter 1 expects number values. But '10:30:00 12:00:00' is text and cannot be coerced to a number.

FormulaThe formula is `=(D26-C26)*24`, where C26 and D26 are formatedformatted as time, E column is formatedformatted as a number.

``````Start time   |    End Time   |  Time difference
-------------+---------------+-----------------
11:30:00 |    12:45:00   |     1,25
-------------+---------------+-----------------
09:20:00 |    10:30:00   |
11:35:00 |    12:00:00   |    #VALUE!
-------------+---------------+-----------------
``````

In the 3rd column I have a formula that calculates the difference in decimal number. 1st row works, can I make it work with the 2nd row without splitting the cell?

This is the error I get when I hover over #VALUE: Error Function MINUS parameter 1 expects number values. But '10:30:00 12:00:00' is a text and cannot be coerced to a number.

Formula is `=(D26-C26)*24`, where C26 and D26 are formated as time, E rowcolumn is formated as number.

added 9 characters in body; edited title
user79865

# Google spreadsheet 2 rows 1 cell formula How to calculate with cells that contain two values separated by linebreak?

``````Start time   |    End Time   |  Time difference
-------------+---------------+-----------------
11:30:00 |    12:45:00   |     1,25
-------------+---------------+-----------------
09:20:00 |    10:30:00   |
11:35:00 |    12:00:00   |    #VALUE!
-------------+---------------+-----------------
``````

In the 3rd column I have a formula that calculates the difference in decimal number. 1st row works, can I make it work with the 2nd row without splitting the cell?

This is the error I get when I hover over #VALUE: Error Function MINUS parameter 1 expects number values. But '10:30:00 12:00:00' is a text and cannot be coerced to a number.

Formula is =(D26-C26)*24`=(D26-C26)*24`, where C26 and D26 are formated as time, E row is formated as number.