Date/Times in tables

[unclefink]

Can someone help me with the best way of setting up a table containing the following date/time fields.

StartDate
StartTime
EndDate
EndTime

Ultimately I will need to be able to subtract these date/times to get a total time between the two. Should I combine the start date and times in one cell or keep them separate.

In either scenerio, how do I subtract the two in a query for a report?

Respectfully,

 

[Isskint]

I would suggest using a single field (date/time dd mm yy hh mm ss) especially if there is any possibility that you will calcualte time across midnight.

As for calculating in a query, create a calculated field EG Duration:[EndTime]-[StartTime]. You would need to format it for display eg HH:mm:ss etc