It all depends on how big you want your mod to be :lol:
If you want to just change a few things, add 5 units etc, it shouldn't take long.
If want to make a huge mod, with all sorts of tweaks, tons of new units, totally changed gameplay etc, it'll take a lifetime :)