I have a spreadsheet that has some auction information, unfortunately the auction end date is not shown, but rather at the time of the gathering 12/1/2012 1:00pm

COLUMN B2 and on have the following
B2= 2 DAYS 0 HR 2 MIN

b3..b200 have different days and hours and minutes renaming, how can I calculate the auction end date? there are over 200 records.


thanks in advance