Determine Time

[Stangleboy]

I have 2 fields on my form and I need to calculate time. I have a StartTime (DD/MM/YYYY HH:MM) and a StopTime (DD/MM/YYYY HH:MM) and I need to determine how much time was spent in minutes in a separte field. This is a piece of cake in Excel but Access doesn't work the same. Help!

 

[willir]

Access has similar abilities

DateAdd
DateDiff

In your case, DateDiff is more suited

DateDiff("n", StartTime, StopTime)

Richard

 

[Stangleboy]

I am getting "#Name?" what format should this be fixed, standard or general format? Thanx!

 

[cityboy3]

make sure you put an = in front of the calculation. i.e., the control source for your text box should read:

=DateDiff("n", StartTime, StopTime)

 

[Stangleboy]

Thank you both, I had another stupid moment with the "=" symbol.