I need to convert a time, 01:45:01 to show the equivalent time in 24 hour format, the data is presented to me in this format. Times do not cross midnight. I need to see the above in this format 13:45:01, how do I do this.
Are you sure you don't already have it in 24hour format and it is simply the case that it is 1:45 in the morning? Unless you have an AM/PM after the number, I would have thought it is already in 24hr. Does Excel recognise it as a numeric (time is numeric)? If you click on the comma icon (ie ',') on your toolbar, does it convert the time value to a number (like 0.075 for example)?