B
Beeyen
I have a situation as follows below; I am having problems mostly with coding
the conversion for the date and time to total the minute. What would suggest
as the event procedure? Or is there an easier way to accomplish the results I
am trying to achieve?
Production Completed [Date/Time field] [Check Box = Yes] Selecting the
Check Box populates the current date and time
Total Time to Complete [Total Minutes field (auto-populates)] A start time
field which has the date and time called [Assigned Time] located in another
sub-form tab, this minus the Production Completed [Date/Time] field above
equals the [Minutes] field.
So; Production Completed (in Date/Time) (minus) Assigned Time (in Date/Time)
(equals) Total Time to Complete (in minutes)
Your experience and any assistance you can provide would be greatly
appreciated.
Thanks
the conversion for the date and time to total the minute. What would suggest
as the event procedure? Or is there an easier way to accomplish the results I
am trying to achieve?
Production Completed [Date/Time field] [Check Box = Yes] Selecting the
Check Box populates the current date and time
Total Time to Complete [Total Minutes field (auto-populates)] A start time
field which has the date and time called [Assigned Time] located in another
sub-form tab, this minus the Production Completed [Date/Time] field above
equals the [Minutes] field.
So; Production Completed (in Date/Time) (minus) Assigned Time (in Date/Time)
(equals) Total Time to Complete (in minutes)
Your experience and any assistance you can provide would be greatly
appreciated.
Thanks