I reveived the very valuable information below for LBass. It work perfectly. But after looking at the data, it calculates all hours in in a week. Now I am getting into an area that I am less familiar. My question; is there a way to eliminate weekend hours and only calculate the hours Monday...
I am creating a formula field in Crystal Reports. I have the formula named and am having trouble with the syntax. I need this to be a conditional formula and the result will be the time difference between a dates/time field based on a condition.
The fields are:
{Schedule App_DtTm} which...
I have a question about caluculating dates/times:
I have a report that that uses the following fields; {Schedule.ApptDtTm} and {Schedule. Activity} that gives me a time-line of scheduled appointments based on the activity. The results of my report looks like this:
Patient: XXX
DATE/TIME...
I need help with a report on two field with two separate data selections on these two field and show the results in the same report.
The two fields are {Schedule.Activity} and {Schedule.Status}
I need to select:
From the {Schedule.Activity} I need to select the activity [“1”, “2”, “3”] where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.