Forum Discussion
Custom Time format
Hi Morgan,
It doesn't matter in which format you show your date/time, on behind in any case will be some number which you may add/subtract. Just take into account days are integers starts from 01 Jan, 1990 and time are decimals, e.g. 1 hour = 1/24. Thus your date/time
2018-10-04 20:40:35.120
formatted as
yyyy-mm-dd hh:mm:ss.000
in General format will show
43377.8615175926
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
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.
They're not aski if that's what you mean. they're just numbers. Isn't there a way to make a custom format so I could do that though? I've seen you can make new formats.