Forum Discussion
woip33
Apr 02, 2024Copper Contributor
Excel substracting time t1 - t2 (millisecond) error
It is not possible to substract time to the nearest millisecond substracting time =T2-T1 expressed as hh:mm:ss.000 returns a #VALUE! error 18:13:35.033 18:13:03.438 #VALUE! substractin...
Detlef_Lewin
Apr 02, 2024Silver Contributor
It works for me. But I have to use the comma as a decimal separator.
- woip33Apr 02, 2024Copper ContributorThanks for the reply, I tried the comma without success.
my long time customized format in the control panel "region" setting is currently
HH:mm:ss.sss
still getting a #VALUE! error when using ss.sss instead of ss