Time calculation using AppGini 22.14

[Moh Youba]

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

[pbottcher]

Hi,

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

[Moh Youba]

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.

Sans titre 5.jpg (38.66 KiB) Viewed 1012 times

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