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.