Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2016, 08:28 AM
jeffreybrown jeffreybrown is offline Time formulas Windows Vista Time formulas Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

It sounds as if when the user enters the logon in A2, you want H2 to capture the time the entry was made.

This can be done be formula, but it can't be made to be static unless you use VBA.



The formula in H2 copied down would be =IF(A2<>"",NOW(),"")

but you have to place a time format on the cell on you will just get numbers.

The NOW() function in the formula is Volatile means if you select anything on the spreadsheet the time will change...it's dynamic.

You can test this by selecting F9 and you'll see the time change.

So, bottom line, if you want to lock in the time when A2 is updated, you'll need VBA.

Do you want to go this route?
Reply With Quote
  #2  
Old 11-26-2016, 10:31 AM
Bdcrawford Bdcrawford is offline Time formulas Windows 8 Time formulas Office 2016
Novice
Time formulas
 
Join Date: Nov 2016
Posts: 13
Bdcrawford is on a distinguished road
Default

@jeffreybrown

If you remember the worksheet you helped me with before. This pertains to that same worksheet. As people enter we need to track them coming in so I'm looking for a way to minimize what all needs entered so the time of day will have to be locked.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time formulas Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time CPSmith Excel 1 03-26-2016 02:48 AM
Time formulas Time Stamps automatically changed to same time! hydrogyny Word 4 02-09-2015 08:57 PM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Time & Date Formulas in Graphs Ady_E Excel 5 11-15-2012 05:29 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

Other Forums: Access Forums

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