I have searched a bit and can't figure this out.  I've tried using Now() in the formula along with putting it in a cell and running the formula against it. I have a column of date/times.  I would like to take the current date/time and subtract this column to output the number of hours difference.  I have tried a few things including simply =I1-G1.  I get function MINUS parameter 2 expect number values. But 'Last Played' is text and cannot be coerced to a number.It would be ideal to somehow use Now() in the formula to eliminate the extra column.  I manually entered the dates in Last Played then converted to date/time.Any ideas?
Google sheets - How to use Now() to subtract from column of date/time to get hour difference
google spreadsheets;date