Hi Guys,
Don't worry. I just worked it out. Here is my solution
I created a query with the field as follow:
TotalHour: Hour([CheckOut]-[CheckIn]) & "." & Minute([CheckOut]-[CheckIn])
If anyone knows the better solution, please share your ideas.
Cheers,
Duanchai T.
|