AppGini Community Forums

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

Hi,

maybe you can post what you tried to do so far and what is not working. Then we can try to help you.

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