I found a stored procedure already in my database (via legacy), and modified it to display remaining seconds and lapsed seconds.
SELECT percent_complete, start_time, status, command, estimated_completion_time/1000/60 As 'Minutes to Completion', total_elapsed_time/1000/60 As 'Minutes Elapsed', wait_type, last_wait_type
order by 'Minutes to Completion' desc
This is useful when you must
perform a shrink or another time consuming task. It does not give much help besides "
" and "
" for ad hoc queries though.