Cell A1 1:00:0 2019-1-1
Cell A2 2:00:0 2019-1-1
Cell A3=A2 - A1, custom format is set to [SS], it is concluded that second
Cell A4=2 * A3 calculation correct
cell/A3 calculation error , why?
CodePudding user response:
Calculate the error? Not nearly 48? Time format, just watch the surface, the actual or in the "day" as the unit of value, so can't to show the way to request the calculation results, if not so, need to use=text (... ) function in the same conversion,