Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-31-2016, 04:15 PM
johncena69 johncena69 is offline Excel time formatting, please help. Windows 10 Excel time formatting, please help. Office 2016
Novice
Excel time formatting, please help.
 
Join Date: Dec 2016
Posts: 1
johncena69 is on a distinguished road
Default 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel time formatting, please help. 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
Excel time formatting, please help. Cell formatting for time - Excel 2010 PomDave Excel 5 09-05-2011 10:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft