I Have a Timesheet problem.
Table is :
arpsDesignLogTbl with the following fields
DesignLogID_Pk (AutoNumber)
EmployeeID_Fk (Number)
LoginDate (Date/Time)
LogOutDate (Date/Time)
StartTime (Date/Time)
FinishTime (Date/Time)
the relationships, forms and queries all populate correctly. My issue is calculating the difference between the StartTime and FinishTime to give me a result of X hours
EG: (StartTime) 12:50:00PM - (FinishTime) 13:09:00PM = 12:19:00AM when the result should be 19 minutes
Please help with the correct calculation and the best place to insert it (Query or the Report)