count working times and overtimes (Page 1 of 2)

Hi
This is my project
I have some major problems:

1- in the Form 3 I need the project to calculate the time of work automatically.
for example if a person works from 8:00 to 16:30. in the Form3 the total time should be 8 hours and 30 seconds

2- in the Form 3 the overtime should be calculated like this:
Total time minus 8 = Overtime

3- in the Form 1 when I search a person between two dates for example between 1st of July and 30th of July, in the TableGrid1, the total work and overtime of that person should be calculated automatically

is this possible?

thanks a lot for helping me out guys

in the Form 1 show only work time and overtime. Total time is SUM of work and overtime.
You will complete the search on Form1 yourself.

I think that you can do question 2 yourself. Similarly.

Hi Identity, Hi Sparrow,
There are a number of ways to approach this - have a look at the attachment which might give you some ideas.
At the moment, it doesn't attempt to calculate the elapsed time if the 'finish time' goes past midnight (but it's a simple modification);  I didn't put it in because I didn't know if it's a requirement for your project or not.
Hope this helps,
Derek.

Thank you Derek and Sparrow
Derek your sample gave me some good ideas for my project. thanks a lot

Sparrow your sample works fine and lot of thanks to you, but when I add a new person, I get error.
another important thing is that is there anyway that the total work time for each month is shown in the  Panel1 - Form2 ?
thanks guys. your help means a lot to me.

Hi Everyone
thank you sparrow . your project works great as always.
there is only one problem though. In my own project I can't use Gregorian Calendar so I need a second approach for these kinds of problems.
the only way that I can think of is to use 3 Textboxes for year, month and day in which I insert a date myself.
for example for  the first textbox I type 2023 and the second textbox is 01 for the month of September and the third textbox is the day.
I have attached Sparrow's last sample and I have replaced the DateTimePicker2 in Form3 with my own approach for the date part.
Is it possible to use this kind of approach for date and how it can be used?
Please Check the script and renew it based on my suggestion if it is possible
thank you all

Hi sparrow
you didn't get what I meant
As far as I know there are many calendars and most of the countries use Gregorian calendar but in my country we use Persian Calendar which is not supported in this version of software.
I can't use Datetimepicker because our year is different from yours and when I enter our solar year into the datetimepicker, it is converted to the Gregorian year. I paid  attention to the example you gave but that can not solve this problem.
I think the only solution is the one I suggested.
I'd be grateful if you could help me with my project.

Fine
Don't help me
But know this, I have read all of the parts of  ' property Format ' and tutorials in the site for hours and I have attempted a lot but I cant make head or tail of Gregorian Calendar at all. Changing this Calendar to suit my purpose is beyond me.

http://myvisualdatabase.com/forum/viewt … 834#p43834

You can use one of the following solutions.
1. You can try to set your computer's regional settings to Persian. This will convert the calendar to Persian chronology in the computer and program.
2. However, you can leave as you did earlier and enter the date by hand in the boxes year - month - day separately.
And combine them ( 'string1' || '-' || 'string2' || '-' || 'string3' ) when outputting to another box.
3.Also in SQLite you can use the strftime('%s', '1041-10-10') function to encode dates
and decode it on output strftime('%Y-%d-%m', your date column, 'unixepoch').

For options 2 and 3, you need to familiarize yourself with working with time and strings in SQLite)))
Options 2, 3 have already been partially used in my time coding examples, so I indicated earlier that you have everything to solve the problem.

Can simplify?
It will be very good if you write for yourself what you want from your program.
What data, in what form, on what form do you want to see, etc. ...

Project in the next post

Hi Sparrow
in the project  that you attached, Form2 Button CbMonth shows all the name of the months automatically.
How can I change the name of a month (for example use " 1 " instead of January or " 2 " instead of Feurary) or delete a month?
thanks