[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] Who's doing what this week,Redux (including a request to Stefan Nikolas)
Hi Robert, On Wednesday, 2007-02-14 14:14:08 -0500, Robert Weir wrote: > The existing function deals with whole days. Excel explicitly defines it > that way. Even if you give it a date serial number that is noon one day > to 5pm another day, it will not return a fractional number of workdays. > > I'm not suggesting we expand it to include such a feature. If we enhance the function such that Excel can't calculate it anyway, why not add fractional workdays if those fractions are given in a new optional parameter array? This functions is used to calculate a deadline or similar dates, so including/excluding fractional days seems a valid approach to me. But as said previously, maybe just overkill. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]