Calculate difference of Date Time Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 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.
Click to expand...


HrsWkd: DateDiff("n", TIn, TOut) \ 60 & Format(DateDiff("n",
TIn, TOut) Mod 60, "\:00")
 
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...
 
Back
Top