I think it depends on the problem. I save lots of time when I use my own spreadsheets for specific task that I do a lot. For example I've got a great wind calculation spreadsheet that takes me through all those tedious calculations. I can do in a few minutes what would take hours by hand if I had to go through all those tables over and over again.
For foundations enercalc has been good for me. For retaining walls again Retaining Wall Pro has been a life saver. Retaining walls by hand are a nightmare. I use Desconwin for steel connections and again it saves me tons of time. I think they save lots of time because every project is different. If I designed beam connections everyday using the books would be the quickest. But when I only do a set of beam connections every other month or so then the software really helps. Plus they product connection details via DXF files. Another area where software can help is when designing a simple steel column with an eccentric load on top. By hand it takes a while but on software very fast.
On the other hand I can still do simple beam designs myself very quickly without any software or the book keeping it requires.
I agree with an earlier statement. CAD drafting definately save you time with the changes and it cleaner over the long term.
A warning on Enercalc. I used their new program a few years ago and found three mistakes after using it 4 times. So I dropped it and use their older software when it still makes sense code wise. This was a few years ago so it might be better now.
The spreadsheet programs save me time doing the small repetitive calcs. More powerful programs like RISA 3D save time when the problem is large and complex. So you've got to have a good bit of modeling to do before it will save you time. But the more you use them the lower that threshold is.
I've only had to design one mat foundation but I know dimensional solutions has a program I tried once and it looked pretty good. Again because that is a problem you aren't going to do everyday it will save you time.
I think tracing the loads by hand through the structure saves time versus modeling. And I think doing the actual design routines is faster with the software. Plus you can make changes instaneously.
John Southard, M.S., P.E.