datetime - a few seconds

[amien]

i have this in a pivot:

datetime, date(datetime), time(datetime)

what i want another expression .. same as time(datetime) .. but with a few seconds less

something like 'time(datetime - workloadtime)'

where werkloadtime is a few seconds .. 20, 45, 110 etc etc.

cant get it working with NUM 😞

Thaks in advanced

[#2]

Amien,

I am using QV 9 Sr2 and when I perfrom the calculation you mention in a pivot table it works as expected:

So no use for num here I think 🙂

Regards, Jan

[amien]

Thanks for your reply..

timestamp comes from a datetime field using time(datetime) .. so that works .. the problem is that timpstamp2 comes not from a datetime stamp but is really an integer what contains seconds.

i need:

time(timestamp1 - 20)

where 20 is 20 seconds

[#4]

That is no problem. Just transform the seconds into a number like

time(timestamp1 - (workedseconds/(60*60*24)))

Hope this works for you