I have a need to create a formula which can do the following in Crystal:
Calculate Current Date/Time minus Submit Date Time - This bit Im good with. However i only want it to calculate for Mondays, Tuesdays, Wednesdays, Thursdays or Fridays and only between the hours of 08:00am and 21:30pm.
For example an Order was submitted at 14:00pm on Friday 5th April and the current date/time is 10:00am on Tuesday 9th April. I need the formula to be able to calculate only:
- The 7.5 hours fopr the Friday
- The 13.5 Hours for the Monday
- The 2 Hours for the Tuesday
Total of 23 Hours.
How can i write a formula to exclude any time after 21:30pm at night and before 08:00am each morning and also exclude all weekends so from 21:30pm on Fridays to 08:00am on Mondays?
Really appreciate any help or guidance I am being given.
Reporting using Crystal X1 from a SQL Database.
Many Thanks
Calculate Current Date/Time minus Submit Date Time - This bit Im good with. However i only want it to calculate for Mondays, Tuesdays, Wednesdays, Thursdays or Fridays and only between the hours of 08:00am and 21:30pm.
For example an Order was submitted at 14:00pm on Friday 5th April and the current date/time is 10:00am on Tuesday 9th April. I need the formula to be able to calculate only:
- The 7.5 hours fopr the Friday
- The 13.5 Hours for the Monday
- The 2 Hours for the Tuesday
Total of 23 Hours.
How can i write a formula to exclude any time after 21:30pm at night and before 08:00am each morning and also exclude all weekends so from 21:30pm on Fridays to 08:00am on Mondays?
Really appreciate any help or guidance I am being given.
Reporting using Crystal X1 from a SQL Database.
Many Thanks