Hi The date looks more-or-less l

[etienne123]

Hi

The date looks more-or-less like:

Name Date/ Time Page viewed time elapsed

ABC 14/08/03 11:01:00 Home page 0 secs
ABC 14/08/03 11:21:00 Dir page 1200 secs
ABC 14/08/03 11:30:00 Page 3 540 secs
ABC 14/08/03 12:50:00 Page 4 4800 secs

We have a policy that if a person have been inactive on the website for more than 60 mins, they have to re-authenticate. This would mean that the last entry is actially a new visit.

Do you guys have any suggestions that would enable me to show any visit where the 'time elapsed' field is greater than 3600 secs (60 mins) or equal to 0 secs (0 mins) as a new visit? E.g.

Name Date/ Time Page viewed time elapsed

ABC 14/08/03 11:01:00 Home page 0 secs New visit
ABC 14/08/03 11:21:00 Dir page 1200 secs
ABC 14/08/03 11:30:00 Page 3 540 secs
ABC 14/08/03 12:50:00 Page 4 4800 secs New visit

Thanks,
Etienne

 

[MrBillSC]

If I understand your request properly, you just want a "New visit" message. This could be done with a formula as follows:

If {time_elapsed} = 0 or {tiem_elapsed} > 3600 then "New visit" else " "

Hope this helps