Calculate difference of Date Time Value

T

Tony Ramirez

I have two fields TIn and TOut. They both are Time Date values. I want to
calculate the diffence of these two fields and have the result diplayed in
hours worked. Thanks for your help.
 
J

John

Hi,
Assuming you have a field called HoursWorked

Enter the following as the ControlSource for the HoursWorked Field

=Format([TIn]-1-[TOut],"Short Time")

HTH

John
 
T

Tom G

Where do you enter this string?

John said:
Hi,
Assuming you have a field called HoursWorked

Enter the following as the ControlSource for the HoursWorked Field

=Format([TIn]-1-[TOut],"Short Time")

HTH

John
Tony Ramirez said:
I have two fields TIn and TOut. They both are Time Date values. I want to
calculate the diffence of these two fields and have the result diplayed in
hours worked. Thanks for your help.
Click to expand...
Click to expand...
 
Top