Re: Date and time manipulations

["Andreas J. Guelzow" <aguelzow taliesin ca>]

J.H.M. Dassen (Ray) wrote:

> On Tue, Mar 05, 2002 at 17:43:39 +0100, Rune Mossige wrote:
>
> > However, once I have got my total number of hours, I want to calculate a
> > cost for these hours, e.g. I have adde up 27 hours 15 minutes (27:15), and
> > have a monetary amount, e.g. US$ 995.40, and I want to arrive at a
> > monetary value, US$ XXX per hour...how do I get to this number easiest?
>
> You'll need to convert from the serial type to hours, minutes and seconds:
>
> =(hour(timespent)+minute(timespent)/60+second(timespent)/(60*60)) * hourlyrate


I believe this will cause problems when the time exceeds 24 hours.

Andreas




--
Prof. Dr. Andreas J. Guelzow
http://www.math.concordia.ab.ca/aguelzow