My day1 out time showing as day2 in time as the shift ends after 6AM next date

[Amarjitdash]

Hello Sir,I need a help. Actually I am a admin of a bio-metric device.
There are 3 shifts are going in my office.
In time Out time Date
Shift1 6AM 2PM 5th April
Shift2 2PM 10PM 5th April
Shift3 10PM5th April 6AM 6th April

but the 3rd shift time intime 10PM is taking as In time Out Timeday1 out time 10PMday2 in time 6AMHow can I make it for same date 10PM as intime and 6AM as out time in excel?And also I want to generate it automatically.
I want the Out Time must shown as the same date.
Date Intime Outtime
5.4.17 6AM 2PM
5.4.17 2PM 10PM
5.4.17 10PM 6AMA
and I want to automate the report while generating from web.