Crystal, now I can't reproduce the ### so I don't know what I was doing
wrong on Friday (tired, I guess), but I finally got it. Here's the
complete formula for anyone interested, where B is the later time, A is
the earlier:
=((B2<A2)+B2-A2)*24
and format the cell as Number>Decimal.
Dick
Richard Connors wrote:
The default of the time difference function is, eg, 1:30. If I change
that to number, I get ###.
Dick
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
