time to decimal format 1

[techkenny1]

Hi
Just need some help please on how to get a text box [blue](TDiff)[/blue] which the data type is set to number and field size is set to double.

There are two time fields (Start) and (Finish). I need the [blue]TDiff[/blue] field to show the difference between both time fields as a decimal.

ie: [blue]If the start field has a value of 9.00am and the Finish time field has a value of 10.30am, I want the Tdiff text box to show 1.5[/blue]
Many thanks,

kp

 

[dhookom]

Set the control source to:

=DateDiff("n",[Start],[Finish])/60

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi dhookom,
Many thanks for reply. Works just right.
kp