Forum Discussion
milliseconds diff
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.
- I have time(hour, minute, second and millisecond) and I need to get the millisecond for the entire column. How to convert all the date parts into only millisecond column.. Thanks
