The US state department has some estimates of time to become proficient in target languages for English speakers. Germanic and Latin based languages take the least amount of effort:
A story I've heard first hand is that after the program, department staff can discuss diplomacy in the target language, but struggled to order a coffee!