i created a virtual column that is now()-[jobdate]
How can i have as result time in numer and not in duration?
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
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |