Shift duty Problem changes as date changes.

Hello to All Experts,
I need a help. Actually I am a admin of a bio-metric device.
Shifts work is going in my office for 5 days. 5th to 9th April.


In Time Out Time
10PM 5th April 6AM 6th April
10PM 6th April 6AM 7th April
10PM 7th April 6AM 8th April
10PM 8th April 6AM 9th April
10PM 9th April 6AM 10th April

How can I will do it?



But the date changes at midnight. But System generated excel report shows as

In Time Out Time
00:00:00 10PM 5th April
6AM 6th April 10PM 6th April
6AM 7th April 10PM 7th April
6AM 8th April 10PM 8th April
6AM 9th April 10PM 9th April
6Am 10th April 00:00:00

I want the correct report. As 10 PM as in time and 6AM as out time.


In Time Out Time

10PM 5th April 6AM 6th April
10PM 6th April 6AM 7th April
10PM 7th April 6AM 8th April
10PM 8th April 6AM 9th April
10PM 9th April 6AM 10th April



How can I will do this. Please guide me.