TimeSheet Calculations - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

TimeSheet Calculations

Howard Chapell

3 years ago

I have a Time Sheet which records Name of Boat Worked On, s - Start and Finish Times, Materials Used and Costs Incurred in one Record and displays it on a Continuous Form. I have attached a Timer with start and Stop Buttons. I want to remove the Finish Time drop Down Box and replace it with a Finish Time which gets its value from the Addition of StartTime + Whatever value is in the Timer Box once Stop has been Clicked. The StartTime is Formatted as Medium Time, and the Timer Box is Formattted as hh:nn:ss. Can someone please suggest the best solution to achieve this

	Howard Chapell OP @Reply 3 years ago

Richard Rost @Reply

2 years ago

Sorry for taking so long to reply. I would still leave the end time because people always forget to click the stop on the timer; then they have to go and change it, or they want to maybe add a few minutes here and there. So I wouldn't take it off the form, but what you would need here is in the click event for your stop button, you could just add that time value to the start time and put it in the end time box. Now I can't tell what your skill level is because I can only see that you're a gold member with a couple of my beginner classes. So if you're comfortable with VBA, I can explain to you how to do this with a little bit of programming if you still need help with this.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View