Calculating difference between 2 time fields

[optiplex]

I have 2 time fields(short time) and I like to calculate the difference between them in a third field.
I've done two tests:

LastTime-FirstTime=1.03
(format of the 3rd field is short time)
LastTime-FirstTime=0,04375
(none format of the 3rd field selected)

What kind of format must I use in the third field to get the difference in minutes. I'm using 24hr clock.

/opti

 

[JerryDennison]

Use the DateDiff() function. This will give you the number of minutes between the two times:

DateDiff("n", FirstTime, SecondTime)

 

[MichaelRed]

You could also try this, to get a "Datr/Time" formatted varaible.

? Format(DateDiff("n", FirstTime, SecondTime)/1440, "Short Time&quot


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over