Re: Date and time manipulations

["J.H.M. Dassen (Ray)" <dm zensunni demon nl>]

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

HTH,
Ray
-- 
Professionele hackers kunnen uw bedrijf veel schade berokkenen.
        Snail-mail spam van het Nederlands Normalisatie-Instituut