Duration in hours formula returning #INVALID VALUE
Hello, trying to calculate the duration in hours between two dates, see below:
But the formula returns #INVALID VALUE.
After reading another help post, I have edited the column properties so that the data type is date, but doing so removed the time stamp and the formula still returms #INVALID VALUE.
So now I have two questions:
- Have I permantently lost my time stamp data by switching the column properties?
- What am I doing wrong in this formula?
Thanks in advance fror the help.