calculated time difference. 1

[EM1107]

Good day everyone.

I am not an expert in MS Access and just started using it.
I have figured how to calculate time difference but as it is it only appear on my table while I add the time start and time stop.
My next step is to store this data into a column so that I can see the the value when I am looking for it.

As it stand I can see it when I add the time but once I save it and close my table the time difference is not stored in my table.

So in my table I have the following columns:

Start time, Stop Time and TOTAL Time.

I would like my TOTAL TIME to be stored in my database column.

Any Idea would be appreciated.
I have added a screen shot of my table to better understand.

 

[Andrzejek]

2 solutions come to mind...
1. Create a query where you can calculate your time difference
or - better yet
2. Use a calculated field in an Access table

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[strongm]

If you have start time and stop time in your table, why do you also need total time, given you can calculate it whenever you need it? You may have a very valid reason, but technically, storing calculated values is a violation of database normalization.