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

(cristina cicero) #1

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

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

(Aleksi Alkio) #2

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