Subject | Re: RE: [firebird-support] How to do Time calculation |
---|---|
Author | Mark Rotteveel |
Post date | 2009-12-18T14:39:33Z |
> huh?Do you need to be spoon fed the answer? If you can get the difference between to consecutive entries of an employ then sum them, then you can sum the total over all employees.
> the result is a decimal. The integer part is number of days. The decimal
> part is a fraction of one day.
> 1.5 = 24+12= 36 hours.
> 1.05892 = 25.41408 hours or 1 day 1 hour 24 minutes 51 secs
>
> Alan
>
>
> Total time period means total hours and minuts worked for all employees
> for each day is needed.
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser