i created a virtual column that is now()-[job...

i created a virtual column that is now()-[jobdate]

How can i have as result time in numer and not in duration?

0 1 275
1 REPLY 1

You need to convert the duration. You can do that when reading hour and minute from that duration (and maybe seconds if needed). HOUR(NOW() - [JOBDATE]) + MINUTE(NOW() - [JOBDATE]) / 60

Top Labels in this Space