Dotan Cohen wrote:
I knew that I was using the wrong term, but what I meant was: "a way
to tell the computer that an integer [0,23] should be read as
belonging to the hour".
If [0,23] means two integers 0 and 23 to be read as hours and minutes:
A1: 0
B1: 23
other cell, formatted as time: =A1/24+B1/1440
No, [0,23] means "all whole numbers from zero to twenty-three
inclusive". It is a standard mathematical shortcut, I apologize for
assuming that the list would be familiar with it. Actually, I have two
errors in here, but if there are no mathematicians present then I
won't bother correcting them!
I see. =A1/24 formatted as time gives the correct value, a value where
HOUR(value) gives the same integer [0,23] as in A1 and where time format
[HH]:MM shows [0,23]:00
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
