|
|
#1
12-31-2016, 04:15 PM
|
|||
|
|||
Excel time formatting, please help.
I am having trouble sorting my column C from largest to smallest in time.
I need a way to format it quick because my program scrapes in seconds, minutes, and hours. S=Seconds M=Minutes H=Hours Here is a screenshot: http://prntscr.com/dq6eba I can't sort based on numbers because my numbers have different units. I need to be able to do it quickly because I have a lot of data that I'll be working with so if theres a way that I can tell excel that S is seconds, M is minutes and H is hours and then with a click of a button to sort from highest to smallest that'd be great. Can anyone advise please. 
|
|
#3
01-01-2017, 03:20 PM
|
|||
|
|||
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 time formatting
|
CLEMMON | Excel | 3 | 08-26-2016 08:08 AM |
| VBA Word Table - Select More than 1 Column at a time - Apply Formatting | jc491 | Word VBA | 12 | 09-24-2015 06:03 AM |
| Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |
| Formatting Merged Time Values Between Excel & Word | JennEx | Mail Merge | 1 | 07-12-2012 02:54 PM |
|
Cell formatting for time - Excel 2010
|
PomDave | Excel | 5 | 09-05-2011 10:49 PM |
Windows 10 
Office 2016
Linear Mode
