Dear all,

Many thanks for the recent posts on calculating time differences, but im still having problems with this.

I have two fields inside a recordset which are type text, they have captured the time using the 'time' function. The field therefore looks something like this 3:09:31 PM.

The fields are used for capturing login and logout times.
First field 3:09:31 PM
Second 3:15:16 PM

Now i don't need to work out date differences, only times. But i obviously want to return something like 6 mins so many seconds, instead of xxxx seconds. Can someone pls point me in the right direction.

Many thanks for all your help.