In a select statement like below within SQL Server:-
,[Duration] / '60' as [Hours]
is it possible to split the duration hours on the basis of start and finish times. For example, if timein is after 0800 but before 2100 and the day is a weekend, can a new field be created with the calculation of the hours between these times, say WeekDayNet.
If hours over 2100, can these be added to say a NightNet column in the view.
Just looking for ideas on how I should go about this and appreciate any guidance. Thanks. SJ