Forum Discussion
milliseconds diff
Taking into account that in Excel 1 Hour is equal to number 1/24, in one hour 60 minutes, etc. difference in milliseconds could be calculated as
=(B1-A1)*24*60*60*1000
SergeiBaklan Thanks for reply.
Still getting #VALUE!
In what format-cell should A1 & B1 be?
Both have data in YYYY-MM-DD HH:MM:SS:SSSS format
SergeiBaklan Thanks agai.
It helps. I need to change :ssss to .sss and reproduce file.
Any other format I can use instead of re-create file?
Thanks for suggestions.
If millisecond are separated by colon, entire datetime is represented as text, As variant you may parse such texts on two parts separating milliseconds, convert both parts to numbers and sum them. Concrete formulas depends on source format, e.g. milliseconds are always have fixed length or not.
One more variant is split datetime on parts with Text to Columns and after combine columns back by formulas.
But perhaps it'll be easier to correct source data.