Forum Discussion
Morgan Shumaker
Oct 04, 2018Copper Contributor
Custom Time format
How do I make a time format including days and miliseconds like dd:hh:mm:ss:mls so I can use formulas to add and subtract times in this format? cause I have a bunch of data using this format that I w...
Morgan Shumaker
Oct 04, 2018Copper Contributor
nope. I've got no choice. dd:hh:mm:ss:mls is the exact format of the time data... and that's not gonna work because it doesn't. what do I do? Cause I've tried that
SergeiBaklan
Oct 04, 2018Diamond Contributor
Are your date/time cells text or numbers? If numbers there is no such format as dd:hh:mm:ss:mls, that could be dd:hh:mm:ss.000. If text - when you need to transform it to numbers to add/substract.
Could you please attach some sample of what do you have?
Example with numbers formatted in date/time is here.