Excel Spreadsheet Using Google API's

Hi guys I know this can be done but I can't get it to work. I need to basically have an Excel spreadsheet whereby I can enter two suburbs, and have a function use Google Maps to work out the travel time (by car), as well as the travel distance between those two suburbs, or even two specific addresses. I'd also like the ability to add in up to 5 or 6 different addresses and have a total travel time and distance. I then would like it displayed in hours and minutes. i.e. 1:30 (one hour and 30 minutes). Any questions let me know!