Subject Re: RE: [firebird-support] How to do Time calculation Vishal Tiwari 2009-12-19T03:25:59Z
Thanks for ur efforts Mark.

i hope u didn't understand the requirement.

Thnaks for ur "Spoon fed" reply

Vishal......

--- On Fri, 18/12/09, Mark Rotteveel <Avalanche1979@...> wrote:

From: Mark Rotteveel <Avalanche1979@...>
Subject: Re: RE: [firebird-support] How to do Time calculation
To: firebird-support@yahoogroups.com
Date: Friday, 18 December, 2009, 8:09 PM

> 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

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

[Non-text portions of this message have been removed]