timestamp function
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Timestamp function!

resolvedResolved · High Priority · Version 2007

replyReply Wed 21 Apr 2010, 13:34Delegate Angelo said...

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

For upcoming training course dates see: Pricing & availability

replyReply Thu 22 Apr 2010, 11:17Trainer Jacob said...

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.

 

Please browse our web site to find out more about
excel consultants and other Microsoft training courses.

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard