How to get Total Time difference between two text fields in _ _:_ _ time format

[behnam]

Hi,

i have two text fields called start and end time with and input mask which makes the format _ _ : _ _, ie. 12:10. The time goes up to 24:00 (using military time). I want a third text field called total duration to be the difference between the end time and start in minutes. Can someone help me achieve this, thanks.

[ItsMe]

Are you familiar with VBA? I suspect you are going to need to do some data type conversion. What data type is the field that stores the time values?

[behnam]

I am familiar with vba. The data types are text. If you simply say the procedure i will be able to code it.

[ItsMe]

You will want to declare a couple variables of type Date. Initialize them using the fields that have the text that represent the time.

Use the DateDiff function to calculate the difference between the two variables.

I think that should do it. When you add text to a date field or initialize a date variable that represents the time only, Access will add a default date to complete the missing info. Make sure you are making provisions for understanding AM and PM. I believe Access will assume 24hr clock if you do not include the AM or PM syntax. Use the immediate window and or step debug to verify variable values as they are initialized.

EDIT: You may have to employ the Left() or Mid() function to add the semicolon to the text before initializing the Date variables.

[behnam]

Thanks,

i used the DateDiff Function with the following code and it worked.

text111 = DateDiff("n", [Start], [End])

Start and End were date/time fields and the difference in minutes (n signifies minutes) goes into text box "text111".

[ItsMe]

Cool......