i have number of days in decimal format in column A, i m trying to add it to the datetime of column B to get new date time in column C but simpling adding the decimal to the B value & using different method by converting the decimal to days hrs min seconds n then adding it to B vale to get new date 2...but instead of same result in both column i get different results....m attaching the excel file...plz guide
Bookmarks