Curren time (at present time) - arrival time calculation

[#1]

Hi everyone,

My table looks like this:

Name                               Arrival_time

peter                              12/12/2012 04:10:45

andrew                           12/12/2012 10:45:20

John                               12/12/2012 09:30:52

I am planning to create a pivot table and calculate the time difference between the current time and the arrival time and display the difference of time.  It is for sure not a straight subtraction because as the day passes by, the difference between the current time and the arrival time increases.

It would be great if someone can help me out on this please.

Regards,

kv  

[Anonymous]

Koushik,

Using difference is fine, but:

If you use now() or now(1) for the current time, it will be recalculating every second, and use a lot of CPU.  not a good idea.

You can use now(2) - it is the time te document was open, or now(0), the time when it was reloaded.

Regards,

Michael