John Meyer wrote:
...
I am trying to extract the hour from a cell and put it into a second
column, but when I use the HOUR() function all it returns is 12:00:00 AM
This is a little tricky.
Times in a spreadsheet are stored internally as fractions of one day. So
all times, and all the times
Joe Smith wrote:
...
Strangely, Calc chooses to display the result as if it were a time
instead of just a normal decimal value. ...
Oops, my bad. It's not Calc's fault at all. The original spreadsheet had
formatted the result as a time, thus the integer results displayed as a
time 12:00:00