However, if the format of the result cell is set to General, you would get the results in fractions/decimals. It is because the time values are represented as fractions of a number in Excel. In the Excel date system, time is stored like this: In Excel’s internal system: 00:00:00 ...
In the Paste Special dialog box, select ‘Values’ in the Paste section (top) and ‘Add’ in the Operation section (bottom), and click the ‘OK’ button. Doing this will add ‘0’ to each cell in the selected range, and convert the numbers stored as texts to numbers. The Result: C...