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

timestamp function

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

Timestamp function!

ResolvedVersion 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.

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.