Handle Shifting in Attendance

Hi,

I have attendance system in asp.net which takes employeeid, timein, timeout and date. It is working fine.

Problem arise dealing with night shift. In that case employee will timein on 1-jan-2013 at 9:00 pm and timeout at 2-Jan-2013 3:00 am.

How to deal with that.

Hope for usual cooperation.