When using the custom formatting options for dates you can set the time portion and use either hh:mm or HH:MM
Is it normal behavior that when going from MM to mm that the time is returned differently?
My experience is that using MM gives me the minute value of some random time, and is not reflective of the actual value but using the mm I get the accurate time.
My experience is that using MM gives me the minute value of some random time, and is not reflective of the actual value but using the mm I get the accurate time.
Are you sure it’s not the other way round?
This caught me out recently until I figured it out… but from my testing I get this:
MM gives the minute, e.g. 56 from 10:56
HH gives the hour in 24-hour time, e.g. 21 for 9pm
mm gives the month e.g. 07 for July
hh gives the hour in 12-hour time, e.g. 09 for 9pm
Yes, it is the other way around. Even get confused and forget which works and which doesn’t when posting this.
MM gives correct minute reading. mm gives incorrect minute reading.
Never crossed my mind that the mm is still referencing the month. That makes sense as to what is going on.
I usually have to structure to get 9:55 PM as h:MM TT
Thanks for the input as it helped clear up my confusion.
This topic was automatically closed after 14 days. New replies are no longer allowed.
