Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2015, 09:31 AM
Rizwan Anjum Rizwan Anjum is offline Time Problem Windows 7 32bit Time Problem Office 2007
Novice
Time Problem
 
Join Date: Mar 2015
Posts: 4
Rizwan Anjum is on a distinguished road
Arrow Time Problem


I want to insert time automatically in cell but i don't want the time updated automatically..
Let's say column A is a "employee" code and Column D is "Arrival" time. When i type employee code in cell A, then the cell D should show automatically the time employee arrival.......File attached here...
Attached Files
File Type: zip Sheet.zip (7.1 KB, 12 views)
Reply With Quote
  #2  
Old 03-29-2015, 02:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Time Problem Windows 7 64bit Time Problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try this http://chandoo.org/wp/2009/01/08/tim...-formula-help/
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-29-2015, 02:44 AM
Rizwan Anjum Rizwan Anjum is offline Time Problem Windows 7 32bit Time Problem Office 2007
Novice
Time Problem
 
Join Date: Mar 2015
Posts: 4
Rizwan Anjum is on a distinguished road
Default

Wrong.........
Reply With Quote
  #4  
Old 03-29-2015, 03:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Time Problem Windows 7 64bit Time Problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by Rizwan Anjum View Post
Wrong.........
???????????????????????????
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 03-29-2015, 07:43 PM
NoSparks NoSparks is offline Time Problem Windows 7 64bit Time Problem Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
Originally Posted by Rizwan Anjum View Post
Wrong.........
no explanation or clarification there...
so none here either.... Use the Worksheet_Change event.
Reply With Quote
  #6  
Old 04-02-2015, 09:32 AM
Rizwan Anjum Rizwan Anjum is offline Time Problem Windows 7 32bit Time Problem Office 2007
Novice
Time Problem
 
Join Date: Mar 2015
Posts: 4
Rizwan Anjum is on a distinguished road
Default

help me pls............
Reply With Quote
  #7  
Old 04-07-2015, 09:17 AM
Rizwan Anjum Rizwan Anjum is offline Time Problem Windows 7 32bit Time Problem Office 2007
Novice
Time Problem
 
Join Date: Mar 2015
Posts: 4
Rizwan Anjum is on a distinguished road
Default

hellooo
WebRep

[IMG]chrome://wrc/skin/png/line-dark-horizontal.png[/IMG]Overall rating
[IMG]chrome://wrc/skin/png/line-dark-horizontal.png[/IMG]

<img id="wrccat_shopping" height="30" width="30"><img id="wrccat_social" height="30" width="30"><img id="wrccat_news" height="30" width="30"><img id="wrccat_it" height="30" width="30"><img id="wrccat_corporate" height="30" width="30">
<img id="wrccat_pornography" height="30" width="30"><img id="wrccat_violence" height="30" width="30"><img id="wrccat_gambling" height="30" width="30"><img id="wrccat_drugs" height="30" width="30"><img id="wrccat_illegal" height="30" width="30">
[IMG]chrome://wrc/skin/png/line-dark-horizontal.png[/IMG]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with time in report download rlsamson Excel 3 12-05-2014 10:27 AM
Time Problem Date--Time shortcut problem markg2 Excel 3 10-27-2012 03:49 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Time Problem Newbie Working Time Problem olebucky Project 4 10-10-2011 04:44 AM
Outlook 2002 Time problem mwsltd Outlook 0 04-23-2010 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:33 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