Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2017, 03:43 AM
sprit36 sprit36 is offline separates a cell that has two hours Windows 10 separates a cell that has two hours Office 2010 64bit
Novice
separates a cell that has two hours
 
Join Date: Jul 2017
Posts: 9
sprit36 is on a distinguished road
Default separates a cell that has two hours

I need a macro that separates a cell that has two hours, leaving a frame on the first cell, insert a new column and put on the other timeline. Attach example. Thanks

Sorry I was wrong, you can move this topic to the VBA section
Attached Files
File Type: xls Sample time.xls (31.5 KB, 16 views)

Last edited by Pecoflyer; 07-18-2017 at 11:45 PM. Reason: Moved to VBA section
Reply With Quote
  #2  
Old 08-20-2017, 05:40 PM
charlesdh charlesdh is offline separates a cell that has two hours Windows 7 32bit separates a cell that has two hours Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Your sample file leaves a question.
In your example you have "Emp 3 and 4" with two time values in column "C".
Where does the second time value come from for the other Emps that goes in column "B"?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
separates a cell that has two hours Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
separates a cell that has two hours If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
separates a cell that has two hours Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
Cell with hours meninio Excel 3 02-11-2011 06:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 AM.


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