var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: time card hours / calculating time
I've been searching/playing all night on this with no luck. I'm looking to find the time difference between the following:
TimeArrive - TimeCompleted = TotalTimeSpent (in short time)
Do I do this in table: design view/default value or in a query, and if so how? If possible give details - I'm new but very eager to learn!
You do that in a query.
A simple SQL statement will look like this, the table where your TimeArrive and TimeCompleted is strored is called TimeTable:
SELECT TimeTable.TimeArrive, TimeTable.TimeCompleted, Format([TimeArrive]-[TimeCompleted],"hh:nn") AS TotalTimeSpent