> > 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.

BTW: How are you going to determine what entry is a login and what entry is a logout. What if your application goes down and didn't log the login or logout?
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser