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
Source Link
user0
  • 23.8k
  • 8
  • 42
  • 69

I've got a Google spreadsheet that looks like this:

 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.

I've got a Google spreadsheet that looks like this:

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 column is formated as number.

I've got a Google spreadsheet that looks like this:

 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 text and cannot be coerced to a number.

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

added 3 characters in body
Source Link

I've got a Google spreadsheet that looks like this:

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.

I've got a Google spreadsheet that looks like this:

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 row is formated as number.

I've got a Google spreadsheet that looks like this:

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 column is formated as number.

added 9 characters in body; edited title
Source Link
user79865
user79865

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

I've got a Google spreadsheet that looks like this:

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.

Google spreadsheet 2 rows 1 cell formula

I've got a Google spreadsheet that looks like this:

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 C26 and D26 are formated as time, E row is formated as number.

How to calculate with cells that contain two values separated by linebreak?

I've got a Google spreadsheet that looks like this:

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 row is formated as number.

added 216 characters in body
Source Link
Loading
edited body
Source Link
Loading
formatting
Source Link
Vidar S. Ramdal
  • 16.2k
  • 11
  • 65
  • 79
Loading
Source Link
Loading