Crystal report night shif problem

[tis707]

Hi all

some problem in while doing the shift

attaching image file of report and database table design and the views

i have startdatetime and enddatetime of files
i need to get daily accountability of employee
in a day he can do so many files for every file startdatetime and enddatetime is entered into database

so i am doing min of date as first login and max of date as last login and getting time diff from that
for the ningh shift i am facing problem
shift timings are
6.30 to 2.30
2.30 to 10.30
10.30 to 6.30

for the night shift when employee started a file at 10.30 pm and end that file at 11.59 and he will start a file 12.00 on the next day and he might finsih at 6.30 am

please have a look at the attached image(blue color font are the problems)

I am using Crystal reports 8.5 and SQL SERVER 2000