Trouble calculating amount of time...

[agutleben]

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!

[Ender]

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

[Ender]

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?

[Barbecue]

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.