Re: Date and time manipulations

[Rune Mossige <r mossige sensewave com>]

Thanks. This tip works wonderful.

On Tue, Mar 05, 2002 at 10:11:53AM -0700, Andreas J. Guelzow wrote:
> Rune Mossige wrote:
>
> > Hello,
> > I have a very simple time-sheet that I have started on, with simple 
> entries
> > like:
> >
> > Date       Start-time   End-time  Time-spent
> > 17/3/2002  16:30        17:45     1:15
> >
> > I get correct entries for the time-spent when I do 
> (End-time-Start-time), and
> > I also get correct, apparently, when I do a sum of the Time-spent to 
> figure
> > out the total number of hours entered.
> >
> > 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?
>
>
> Time is calculated in days:
>
>
> 27:15:00 is  27:15:00 * 24 hours, therefore
> 995.40/(27:15 * 24) $/hour
>
> Andreas
>
>
> -- 
> Prof. Dr. Andreas J. Guelzow
> http://www.math.concordia.ab.ca/aguelzow
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list

-- 
(-: Hiroshima 45, Tsjernobyl 86, Windows 95 :-)
Rune Mossige             Tlf(Privat): (+47) 51 42 47 71
Brekkeveien 19           Tlf(Work):   (+47) 51 94 68 69
N-4353 Klepp Stasjon     Mobil:       (+47) 908 71 024
NORWAY