You’re offline. This is a read only version of the page.
Announcements
Share
ReportHello community,
Thanks for the final fix.
but I still have questions, I have already designed an app, but now I want to record the working times and I have the following problems:
1. I would like to convert the times into working hours
and displayed in a decimal number (example: from 07:00 to
4:00 p.m. minus a break = 8.0 h
2. I have created a Submit button and now I would like to
that the data I entered in an Excel spreadsheet
be written (I have already tried this according to the
Video unfortunately only with the formula "Patch(table1;"appname")
don't hit it
3. In the data table, he only tells me the names of the fitters
[object_object] to it's a drop down list though
fitter list
I hope you can help me with my problems.
Kind regards
Hello, @Basti1987, for your first question:
You will have to use DateDiff function that returns the difference between two date/time values.
DateDiff( TimeValue("07:00"), TimeValue("4:00"), Hours )
The second and third questions are not clear. Can you please explain more and maybe use some screenshots.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
All responses (
Answers (
6,678
