Subject Re: RE: [firebird-support] How to do Time calculation
Author Mark Rotteveel
> huh?
> 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.

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.

--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser