I have 2 DateTiime fields, ClockTime, and DefaultStartTime.
The ClockTime is the actual time a person clocked into the office, and the DefaultStartTime is the time that work actually starts for the day. The fields are as follows:
2011/04/01 07:35:23 2011/04/03 08:00:00
Now, even though the Date of ClockTime and DefaultStartTime are different, I actually dont want to take the dates into consideration. I just want to calculate the difference between the times ie. 08:00:00 - 07:35:23. Can anyone help?