CrystalReport Time Diff

[PawelR]

Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row) to
dateTime. How in 3th column calculate difftime beetwen this value and
dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.

Thx for yours help
PawelR

[Octavio Hernandez]

Pawel,

You'll have to program a bit using Crystal Reports formula language. First
use DateDiff to obtain the difference between the two dates IN SECONDS, then
use arithmetic formulas in order to obtain the number of days, hours,
minutes and seconds in the difference, and finally build a string in the
format "20 04:15:05" with the temporary variables obtained.

Regards - Octavio

"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row) to
dateTime. How in 3th column calculate difftime beetwen this value and
dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.

Thx for yours help
PawelR

[PawelR]

Thx Octavio,
but I don't quite shure that this is good way. If I use your solution I have
in 3th column string value. If I have string I propabylity can't use
agregate function sum().
Ever rows in first column have start time, second end time and 3th diff
time. On the end my reports I must show total time in job.

U¿ytkownik "Octavio Hernandez" <do****@danysoft.com> napisa³ w wiadomo¶ci
news:%2****************@TK2MSFTNGP10.phx.gbl...

Pawel,

You'll have to program a bit using Crystal Reports formula language. First
use DateDiff to obtain the difference between the two dates IN SECONDS,
then use arithmetic formulas in order to obtain the number of days, hours,
minutes and seconds in the difference, and finally build a string in the
format "20 04:15:05" with the temporary variables obtained.

Regards - Octavio

"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row) to
dateTime. How in 3th column calculate difftime beetwen this value and
dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.

Thx for yours help
PawelR

[Octavio Hernandez]

Pawel,

Make the 3rd column with the difference in seconds, and make it invisible
(Supress). You can sum that column easily. And then at the end of the report
use the formula to present the sum as a string " hh:mm:ss", right below the
4th column, which shows the "hh:mm:ss" for every job..

Regards - Octavio
"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:eB**************@TK2MSFTNGP15.phx.gbl...

Thx Octavio,
but I don't quite shure that this is good way. If I use your solution I
have in 3th column string value. If I have string I propabylity can't use
agregate function sum().
Ever rows in first column have start time, second end time and 3th diff
time. On the end my reports I must show total time in job.

U¿ytkownik "Octavio Hernandez" <do****@danysoft.com> napisa³ w wiadomo¶ci
news:%2****************@TK2MSFTNGP10.phx.gbl...

Pawel,

You'll have to program a bit using Crystal Reports formula language.
First use DateDiff to obtain the difference between the two dates IN
SECONDS, then use arithmetic formulas in order to obtain the number of
days, hours, minutes and seconds in the difference, and finally build a
string in the format "20 04:15:05" with the temporary variables obtained.

Regards - Octavio

"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row)
to dateTime. How in 3th column calculate difftime beetwen this value and
dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.

Thx for yours help
PawelR

[PawelR]

Thx Octavio,
Could you help me? I don't know how present the sum as string "hh:mm:ss".

Pawel
U¿ytkownik "Octavio Hernandez" <do****@danysoft.com> napisa³ w wiadomo¶ci
news:OH*************@TK2MSFTNGP15.phx.gbl...

Pawel,

Make the 3rd column with the difference in seconds, and make it invisible
(Supress). You can sum that column easily. And then at the end of the
report use the formula to present the sum as a string " hh:mm:ss", right
below the 4th column, which shows the "hh:mm:ss" for every job..

Regards - Octavio
"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:eB**************@TK2MSFTNGP15.phx.gbl...

Thx Octavio,
but I don't quite shure that this is good way. If I use your solution I
have in 3th column string value. If I have string I propabylity can't use
agregate function sum().
Ever rows in first column have start time, second end time and 3th diff
time. On the end my reports I must show total time in job.

U¿ytkownik "Octavio Hernandez" <do****@danysoft.com> napisa³ w wiadomo¶ci
news:%2****************@TK2MSFTNGP10.phx.gbl...

Pawel,

You'll have to program a bit using Crystal Reports formula language.
First use DateDiff to obtain the difference between the two dates IN
SECONDS, then use arithmetic formulas in order to obtain the number of
days, hours, minutes and seconds in the difference, and finally build a
string in the format "20 04:15:05" with the temporary variables
obtained.

Regards - Octavio

"PawelR" <pa************@poczta.onet.pl> escribió en el mensaje
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row)
to dateTime. How in 3th column calculate difftime beetwen this value
and dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.

Thx for yours help
PawelR