Convert Time

[William_99]

Hi

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.

Many thanks

William

 

[Richard Schollar]

Hi William

Welcome to the Board!

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)?

Richard