#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
|
|
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 |