But this won't be the way you calculate the hours your customers have to
pay for? ;-)



--
Christian Kaas mailto:christian@...
Client/Server/Internet/Multitier development
http://www.ckaas.de

> -----Ursprungliche Nachricht-----
> Von: Paul Schmidt [mailto:paul@...]
> Gesendet: Montag, 29. Januar 2001 17:54
> An: IBObjects@yahoogroups.com
> Betreff: [IBO] Time Fields
>
>
>
> Here is an interesting challenge to all.
>
> ITable that contains two time values, START_TIME and END_TIME, now I
> want to calculate the number of hours difference between them, with a
> slight twist, according to the following table:
>
> Minutes Start-Time End-Time
>
> < 15 0.0 0.25
> 16 - 30 0.25 0.50
> 31 - 45 0.50 0.75
> 46 - 59 0.75 1.00
>
> So from 14:03 to 14:58, would be calculated as from 14.00 to 15.00
> and return 1.00 hours.
>
> I know that the stored procedure for this, is going to win an ugly
> contest, but I would like to be able to keep the actual physical
> times, as well as the "rounded" times.
>
> Paul
>
>
> Paul Schmidt,
> Tricat Technologies
> Email: paul@...
> Website: www.tricattechnologies.com
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://click.egroups.com/1/11231/1/_/685810/_/980787565/
> --------------------------------------------------------------
> -------_->
>
>
>