(please bottom post)

Richard Connors wrote:
The default of the time difference function is, eg, 1:30. If I change that to number, I get ###.
Dick


Dick:

### usually means the column is not large enough. Can you make the column bigger to see what it says when in a number format?

Crystle

Immanuel CRC Office wrote:

Richard Connors wrote:

I'm using ver 2.0.2 and need to get the difference between two times converted into a decimal, not a time format, ie, I want an hour and a half expressed not as 1:30, but as 1.50. Can't figure this out.

Dick


Dick:

In Calc, which I am assuming you are doing this in, what is the number format of the cell? Is it date or number? This might make the difference.

Crystle



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON   L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to