Hello All
I'm attempting to get the time of hh:mm:ss. However, excel always wants to adjust to an AM/Pm configuration, or a military time. I'm looking for a time to match a stopwatch format.
For example, if I have 1:59:32 for 1 hour, 59 minutes. 32 seconds, then it will remain like this, or if I want to have 32 minutes, 47 seconds, I can simply type 00:32:47. Excel wants to keep changing to am/pm
this is excel 365
Thanks for the help
I'm attempting to get the time of hh:mm:ss. However, excel always wants to adjust to an AM/Pm configuration, or a military time. I'm looking for a time to match a stopwatch format.
For example, if I have 1:59:32 for 1 hour, 59 minutes. 32 seconds, then it will remain like this, or if I want to have 32 minutes, 47 seconds, I can simply type 00:32:47. Excel wants to keep changing to am/pm
this is excel 365
Thanks for the help