The airport is 23 kms from Auckland - at that time of night probably 25 minutes max.
Queen Street is the main shopping Street in Auckland - it is about the same distance from each hotel.
You will need a taxi to get you and luggage to the cruise terminal from the Sofitel.
Which ship are you on ?
https://www.google.com.au/maps/dir/Hilton+Auckland,+Quay+Street,+Auckland,+New+Zealand/Queen+St,+Auckland+CBD,+Auckland+1010,+New+Zealand/Sofitel+Auckland+Viaduct+Harbour+Viaduct+Harbour+Avenue,+Auckland,+New+Zealand/@-36.8452035,174.7574238,16z/data=!3m1!4b1!4m20!4m19!1m5!1m1!1s0x6d0d47f9b83e397d:0xc797af5c706f9874!2m2!1d174.765806!2d-36.8395244!1m5!1m1!1s0x6d0d47e538481e6f:0x78c20fe39d0eb793!2m2!1d174.7646155!2d-36.8506786!1m5!1m1!1s0x6d0d47f3e3707f01:0x6967a72888e638db!2m2!1d174.7574064!2d-36.8449522!3e2