Forum Discussion
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...
See? I need to add subtract this form of data, which excel doesn't do because this time format isn't in the program... at least not yet. I need to figure out how to make that format of math to work.
Again, format itself doesn't do any math. You have number or you have text. If number, you may do any math and present result in any suitable format, date/time in particular. If you have text you need to transform it to number to do the math.
ok then it's a number, so the math part is the messed up part? how would I even know if it's an aski form of number that's actually text?
Morgan, if that is in A1 try to check what will be returned by =ISNUMBER(A1) or =ISTEXT(A1)