Re: European/Negative Date

On Fri, Jan 11, 2002 at 04:00:58PM +0100, Carsten Zerbst wrote:
1. How could I define european date formats ?
Cell Format -> Number -> Custom

I've tried to have a reasonable set of defaults, but there are just
too many combinations to put everything in there.

2. When doing calculations with negative time, there is a kind of
rollover effect. But I realy need negative times. Is there some kind of
workaround ?

start end     should  have    
8:00  15:00   8:00    b2-b1   <== should be -1:00 instead of 23:00

Use a different format.
hh:mm is limited to 0..23
[h]:mm is not.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]