Calculate difference of Date Time Value

[Guest]

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.

 

[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

 

[Marshall Barton]

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.

HrsWkd: DateDiff("n", TIn, TOut) \ 60 & Format(DateDiff("n",
TIn, TOut) Mod 60, "\:00")

 

[Guest]

Where do you enter this string?

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

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.