How to calculate difference between hours field

[poliv]

Hi,

I have a problem to calculate the difference between to fields with the format hh:mm.

Example:

Field_A -> 14:05

Field_B -> 15:10

Difference (Field_B - Field_A)-> 01:05

Thanks

 

[krispi]

Format Field_A and Field_B as 'Short Time'.

Create an unbound control and format this as 'Short Time' as well. Set the Control Source for the unbound control to

=Field_A - Field_B

This should do it.

 

[KenReay]

Hi

See DateDiff() function in help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK