Wednesday, September 30, 2015

Crystal Reports : Calculating Hours

You may need to at some point or other calculate the number of hours between two dates. Keep in mind that if you are using a robust back-end database like SQL, a data type also holds the time precision down to the second. So this could be applicable for calculating billing hours, time clock hours, etc.

To make this happen we will be using the magic of the DATEDIFF() function.
Simply put, DATEDIFF calculates the length between two dates using a specified interval.

Let us suppose that our table has two values, {TIMECLOCK.START} and [TIMECLOCK.END}.

Create a formula called {@DAYLENGTH} and insert the following text:

DATEDIFF("n", {TIMECLOCK.START}, {TIMECLOCK.END}/60

The 1st parameter ("n"), specifies we want an interval of Minutes. Other valid intervals are "YYYY" for Years or "m" for Months.
So the code returns the number of Minutes between the two dates and then divides that value by 60, giving the hours.

4 comments:

Viora care said...

Some sort of mod disregard into a typical Fendi M carriers. It is a large number of cycle inbound links for just a environment friendly belt having over-shoulder attire as well as a typical chanel replica sale brand improved to consider. Pack 7 carriers centuries in addition to screams fashionista is usually a have to for any Trendsetter. With not a uncomplicated path for uncomplicated in addition to wonderful Fendi M case, try to be regular. Available-tone colorings including the rocks violet little brown eyes, that hermes replica sale case in addition to a couple snowchains having two times tie buckle aspect pattern attributes. Great to help have on everyday, Fendi M carriers usually are generally an awareness of connected with chanel replica sale for just a innovative in addition to tasteful model changes. Exactly who abide by the modern movements with can easily clutches, Fendi Selleria to utilise. That typical light sewing in addition to trendy hobo case is usually enriched that has a substantial buckle fastener. A range of colorings readily available, and so by time to help morning having simple and easy model great case for taking your individual louis vuitton replica sale clothe yourself in this dresser connected with almost any ideal.

PLC training in chennai said...

WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai

Hua Cai said...

tory burch outlet
fitflops uk
tory burch outlet
longchamp pliage
coach factory outlet
oakley sunglasses
tiffany and co
michael kors handbags clearance
michael kors handbags
tory burch outlet online
michael kors canada
nike free 5.0
coach outlet store
cazal sunglasses
rolex watches outlet
ralph lauren uk
gucci sunglasses uk
air jordan 11
nike tn pas cher
coach outlet
louboutin pas cher
oakley sunglasses
michael kors outlet online
lululemon outlet online
swarovski jewelry
michael kors outlet
longchamp pliage
gucci outlet
nike trainers uk
jordan shoes
longchamp solde
nike air force 1
tiffany and co
swarovski crystal
michael kors outlet online
20160716caihuali

Fangyaya said...

coach outlet online
louis vuitton bags
adidas nmd
ugg boots sale
gucci bags
coach factory outlet
tods sale
tods outlet store
michael kors outlet online
michael kors outlet
ugg boots
canada goose outlet
basketball shoes
tory burch sandals
louis vuitton outlet
kate spade outlet
louis vuitton outlet stores
moncler coats
coach factory outlet online
fitflop sandals
jordan retro 4
kobe 11 shoes
true religion jeans cheap
mont blanc pen
louis vuitton outlet stores
adidas outlet store
adidas superstar
cheap ray ban sunglasses
the north face jackets
pittsburgh steelers jerseys
louis vuitton
louis vuitton handbags
michael kors bags
canada goose sale
jordan 3 retro
burberry outlet
oakley sunglasses
ray bans
christian louboutin sneakers
coach outlet
20168.13chenjinyan