Hello
How are you doing here, I hope you all doing well.
Please I need help for date and time calculation.
I want to get total time worked and fees
*WORKING HOUR*
- start_datetime
- end_datetime
- total_worked_time
- amount
- total_to_pay
any help please
Thank you
Time calculation using AppGini 22.14
Re: Time calculation using AppGini 22.14
Hi,
maybe you can post what you tried to do so far and what is not working. Then we can try to help you.
maybe you can post what you tried to do so far and what is not working. Then we can try to help you.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Time calculation using AppGini 22.14
Hello
Thank you sir for your comment. My English is not very good to really explain. I found an easy non expert way to do what I want. See image.
heure_t
SELECT `pointage_profs`.`heure_d`-`pointage_profs`.`heure_a` FROM `pointage_profs`
WHERE `pointage_profs`.`idpp`='%ID%'
net_payer
SELECT `pointage_profs`.`montant`*`pointage_profs`.`heure_t` FROM `pointage_profs`
WHERE `pointage_profs`.`idpp`='%ID%'
Thank you
Thank you sir for your comment. My English is not very good to really explain. I found an easy non expert way to do what I want. See image.
heure_t
SELECT `pointage_profs`.`heure_d`-`pointage_profs`.`heure_a` FROM `pointage_profs`
WHERE `pointage_profs`.`idpp`='%ID%'
net_payer
SELECT `pointage_profs`.`montant`*`pointage_profs`.`heure_t` FROM `pointage_profs`
WHERE `pointage_profs`.`idpp`='%ID%'
Thank you