Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Dim strTime As String Set rg = Intersect(Range("G:G"), ActiveSheet.UsedRange) For Each c In rg.Cells If IsNumeric(c) Then Select Case Len(c) Case 1 strTime = "00:0" & c Case 2 strTime = "00:" & c Case 3 strTime = Left(c, 1) & ":" & Right(c, 2) Case 4 strTime = Left(c, 2) & ":" & Right(c, 2) End Select c = strTime End If Next c
|Excel - Scroll Speed||3||26|
|Excel Autofill Dropdown List with Combobox : How to make use of Tab and Enter key to input a value.||5||20|
|In Excel 2007, how do I insert a blank space between two dynamic values in a cell?||3||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!