markthegreat
Technical User
I am trying to right a formula to show hours and minutes from a start date and time to a finish date and time, but not to include weekends and only the times between 08:00 and 16:00. Can anyone help.
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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Ranges And Times
- Thread starter markthegreat
- Start date
- Status
Using DayOfWeek (date) will give you a number, 1 to 7, with Saturday as 7 and Sunday as 1.
If you are selecting from records, this should filter out weekends. A separate selection could be done for time, using 'Datepart' to get hours and minutes.
It helps to give your Crystal version.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
If you are selecting from records, this should filter out weekends. A separate selection could be done for time, using 'Datepart' to get hours and minutes.
It helps to give your Crystal version.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question