Does anyone have any experience on how extra duty usually works with shift workers? Do you have any advice you can provide?

Whenever your shift is, your extra duty will work around that, typically at night under the supervision of the CQ or an NCO detailed to this task.
Be prepared to lose some sleep and not have a lot of free time for Fortnight for the next... wait for it...fortnight.

Your First Sergeant will give you a full block of instruction on how it works. More specifically since he has done his job, he will hand you off to junior NCO to supervise. Basically the way it will or should work with you is that command will acquire your schedule from your first line supervisor and base a schedule of working off your ED from there.

Basically it works like this. If you went in to work at 2400 on Mon and got released at 1200 on Tue you would be given just enough travel time from your job to the point where your ED was to be performed and once you report you would be doing ED anywheres from 4-6 hours. They have to allow you a certain amount of time to sleep, grab chow etc.

Talk to you First Sergeant since he/she is the one that is in charge of you extra duty.