I am trying to design a flexi sheet calculator for work so that the users can use this program to calculate their working hours. They enter their times manually over the week. This is a calculator for them to use at the end of each week to calculate the totals.
Eveyday when you arrive at work you log you enter your time in and log out when you go for lunch. Same thing happens when you come back from lunch - log in your time in and time out when you go home.
All times are in 24 hour clock.
Time In1 (hh:mm)
Time Out1 (hh:mm)
Time in2 (hh:mm)
Time Out2 (hh:mm)
Total hours worked(hh:mm) = (TimeOut1 - TimeIn1) + (TimeOut2 - TimeIn2)
I am not sure how to add or deduct between two sets of times and show the result in hh:mm.
The calculator needs to calculate the number of hours and minutes worked everyday. No seconds required.
Then calculate the total hours worked over 5 days and deduct it from 35 hours which is normal weekly working hours. Any debit or credit hours carried forward to the following week.
I would like the user to be able to simply type 0900 and VB code to convert it to 09:00. Is this possible?
When they type 0900, I would like the cursor to move to the next field automatically rather than having to press the Tab button on the keyboard. Is this possible?
I am new to Visual Basic and trying to learn. If I can do this flexi calculator, it would teach me a lot.
Any help would be grately appreciated. Please do remember I am an idiot when it comes to VB 6.0 but I am very enthusiastic to take your advice and help.