?
Solved

Lotus 123      Elapsed Time

Posted on 2004-03-21
9
Medium Priority
?
429 Views
Last Modified: 2010-04-22

Where can I find a 123 formulae to record elapsed time.  IE  I want to have a button on a spreadsheet when pushed will start the time going and when a second (stop) button is pushed the clock will stop and the elapsed time recorded consecutively in a table.
 
Beyond my capabilities to work out.
 
            Start  @      March 31 2004    1530
            Stop  @      March 31 2004      1640              Elapsed time       0110
         
            Start @       April  01  2004      0927    
            Stop  @       April 01  2004      1001              Elapsed time     0034
 
Dates time etc can be in any format.
 
 
 
                                                                         
Total Elapsed time  0144
     
0
Comment
Question by:sswcharlie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 500 total points
ID: 10697916
You will need two macros to do this in the simplest of ways - as follows:

\start {goto}a1~@now~/rv~~

This inserts the time and converts it to a value so it does not change subsequently

\stop {calc}

This just updates the time which is in cell A2 - see below.

The first macro is called start and the second stop.

Assuming that the start time is stored on cell A1 and underneath it in A2 you have @NOW then in cell A3 you can have +A2-A1. The will give you the difference in the Lotus123 time numbers between when you started the clock and when you finished the timing. Next to A3 you can then use in three columns @HOUR(A3), @MINUTE(A3) and @SECOND(A3).

To smarten it up attach the \start macro to a button labelleled START and macro \stop to a button labelled STOP/UPDATE.

If you already know how to use macros please excuse the following -

In a cell enter '\start    - exactly as written with the apostrophe '
In the cell immediately to the right of '\start   enter {goto}a1~@now~/rv~~
Place the cursor on the cell with '\start in it and go to Range/Name/UseLabels and OK. This with create a macro called \start.
Go to Tools/Draw/Button select range, select the START macro, enter START in the box and the bottom and OK it. In newer Lotus123 it is easier and quicker.

The button will then work the START macro. Do the same for the STOP macro and that's it.

If you want to see an example please place your email address in your profile - not here - and I will then send you an example which you can then experiment with.

Hope that helps
0
 

Author Comment

by:sswcharlie
ID: 10701942
Email on profile.  Thks
0
 

Author Comment

by:sswcharlie
ID: 10721633
Patrick email posted on profile this time
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 45

Expert Comment

by:patrickab
ID: 10723504
sswcharlie - Apologies for not replying earlier but my pc is not usable at home at the moment as we are having alterations done and it is somewhere under a dust sheet. I will re-create the spreadsheet for you this evening at work (where I am now) and forward it to you asap.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 10723535
By the way I've just had a look and your email address in not in your profile. Has someone removed it? I'll be online at about 18:00 GMT this evening so if you can re-post your email address in your profile I will be able to pick it up . I'll let you know after that you can leave it or remove it as you wish.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 10725069
By the way - thanks for the A grade - I've yet to deliver the example ....
0
 
LVL 45

Expert Comment

by:patrickab
ID: 10725443
Example at work is now ready - it's a bit smarter than the one at home - new edition of Lotus123!
0
 

Author Comment

by:sswcharlie
ID: 10730014
Have entered my email again in a different place.  Should be ok this time.  Thanks for all your efforts.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 10730322
Noted - thanks - done.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question