Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating Working Hours

Status
Not open for further replies.

TheBlondOne

Programmer
May 22, 2001
346
GB
I have been using a formula to calculate the number of business hours between two dates. The problem is that the formula is for a later version of crystal and i am using crystal 6. This is the formula

WhilePrintingRecords;

Numbervar Days :={@Working Days};
Timevar SetStart:= TimeVal("08:30");
TimeVar SetEnd:= TimeVal ("17:00");
TimeVar StartTime:=TimeVal({@Call Time});
TimeVar EndTime:=TimeVal({Call Time 2});

Crystal 6 doesn't have the timevalue function, can anyone help me with this please?

Thanks in advance
 
I don't know if it will do what you want but there is a UFL that you can download from Crystal Care Technical support called Date-Time difference ufldtdif.exe. It is suitable for any version from 5 and above. Learn something new every day *:->*
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top