December 10, 200421 yr I have a solution where I would like to track the number of hours, minutes, etc. that a user is in my system. I have the following fields that are trapped at solution entry and exit: Logfile_Action_Start_Time Logfile_Action_End_Time Can anyone point me in the right direction of creating a caclulated field to do this job. Many thanks!
December 10, 200421 yr Just off the top of my head: Hours (calculation, number result) = Hour(Logfile_Action_End_Time - Logfile_Action_Start_Time) Minutes (calculation, number result) = Minute(Logfile_Action_End_Time - Logfile_Action_Start_Time) - Hours
December 10, 200421 yr Probably easier to keep hours and minutes together in one time field: ElapsedTime (calculation, time result) = Logfile_Action_End_Time - Logfile_Action_Start_Time Do you need to count days too?
December 12, 200421 yr With FM7, you have the option of using a TimeStamp field instead of a Time field. That would eliminate the need to do special checks if your time frame extends past midnight.
Create an account or sign in to comment