Hi All,
I'm using Excel's feature to increment time in constant steps (any value, actually). For example, I'm inserting the times:

10:00:00,
10:10:00,
10:20:00,

And let Excel perform the completion.

My problem is that I need a military time formatץ That means ignoring the AM/PM notation.

I can do it with Excel only if the system time format, the one you set in the control panel. The "secret" is not to use the tt in the format: hh:mm instead of hh:mm:tt.

I was wondering if anyone has a better idea, that relays only on Excel and does not depend on the system formats.

Thank you so very much in advance,
Happy Holidays,
Omer.