Time Calculation within Access

[LeeG]

I am new to access and want to create a table that allows me to enter a start date & time and an end date & time then allow me to calculate the minutes out of that day between the 2 times. I have the calculation in Excel but when I have tried to convert the Excel file to Access (I am probably doing something wrong) it has a dippy fir and completly cocks up. No doubt some clever person out there can sort this for me.
One other thing would u be able to calculate the entire list of results excel style????

Cheers

 

[AncientOne]

Look up DateDiff in Help.

 

[neileg]

You'll need to store your start and end times in a table. Then you calculate the difference using datediff in a calculated field in a query, or possibly in a form.