Thread: Sort times.
View Single Post
  #5  
Old 27th July 2015, 07:48 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Select the column the times are in, right click-format cells-numbers-times, then select the last option 13:30:55

If that doesn't work it may require extra formating in the way of a formula to get what you want.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote