timestamp function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Timestamp function!

Timestamp function!

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

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.

View all Excel hints and tips


Server loaded in 0.09 secs.