98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Timestamp function!
Timestamp function!
Resolved · High Priority · Version 2007
Angelo has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Advanced course
Access VBA course
Timestamp function!
I'm trying to make a function that give the time within a formula WITHOUT updating...The idea is to create a timestamp function so I can track how long it takes me to do a repetative task.
This is what I have so far, but it doesn't work :(
I'm filling in values in a column A1 and I'd like the time at which I fill in the cell to appear in the cell next to it. Later I will take the average to see how long it takes me to fill in cell in A1. I had this:
=IF(ISBLANK(A1)=FALSE,TEXT(NOW(),"hh:mm:ss AM/PM"),"")
but NOW() keeps updating, so I made the following function:
Function timestamp()
Dim tiemstamp As Date
timestamp = Text(Now(), "hh:mm:ss AM/PM")
End Function
I then write in B1, "=timestamp()", but got, "#NAME?"
had it worked, I would have changed B1 to,
"=IF(ISBLANK(A1)=FALSE,timestamp(),"")"
but my function doesn't work I guess. Any advice? Try it out, I think this would be a very useful function.
I KNOW ABOUT CRTL+SHFT+; but I dont' want to have to do this manually as I keep forgetting :p
Thank you in advance
RE: timestamp function!
Hi Angelo
Thanks for your post and detail on what you are trying to complete. We have had a look and haven't found a quick solution.
We would need a few hours of dedicated research to see if we can come up with a solution and will also need your working files. This sort of work involves trainer development time and is billable, however we won't start any work until the scope is agreed by both parties.
If you would like to discuss this further please let us know.
Regards
Jacob
Thu 29 Apr 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Page Break Preview in Excel 2010 (Hint/tip)If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want. |