How to get mins

[nikol]

Hi,
I have start_date & end_date columns. I used
dateDiff ("h", {start_date}, {end_date}) to get the hours.
Its giving 4.00 hrs
3.00 hrs.Truncating the mins.
I'm trying to use "mins/60" to get whole hrs & mins also.
Is there any other way I can do.

 

[lbass]

Please see faq767-3543.

-LB

 

[BoniR]

Hello...
You didn't mention what version of Crystal you are using but this may help...
if you use "n" instead of "h" it will give you the minutes...dateDiff ("h", {start_date}, {end_date})
Once you have the total minutes you can divide by 60 to get the hours...
Once you have the total hours in minutes you can subtract this number from the first number to get the leftover minutes...
So...

First formula: @TotalMins

dateDiff ("h", {start_date}, {end_date})

Second formula: @CalcHours

({@TotalMins})/60

//you may also have to use a function to drop everything after the "."

Third formula: @CalcMins

({@TotalMins}) - ({@CalcHours} * 60)

Fourth formula: @TotalHoursMins

{@CalcHours}&"hours and"&{@CalcMins}&"minutes"

//you can change this concatenation to whatever format you desire...just make sure to use "&" not "+"

Hope this helps!
B~


Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269