how to sum (textbox with HH ddMMyy) + (number of Hours)
Result as HH ddMMyy
What is in
- ROB
- TOV
- DISCH
- RATE
?
Also, why didn't you use date and time pickers for this?
By the way, a .Text can never hold an Instant:
ROB,TOV,DISCH,RATE are numbers
REMAIN ON BOARD >>ROB=TOV-DISCH (total volume- discharged)
RATE>> NUMBER/HOUR (discharging 1000 CBM per Hour)
SO
FROM NOW() OR ANY TIME/DATE
I HAVE TO ADD SOME HOURS >>> ROB/RATE
CALCULATION==
TIME DATE + DURATION( DAYS,HOURS)
RESULT IN FORMAT >> HHmm ddMMYY
And what is CBM ?
It would help to know what your application does.
From what I have seen so far, it is either a fish farm or a Japanese subway simulation.
cubic meters
app collecting update ROB, RATE at specificTIME HHmm ddMMYY
remain on board ROB / RATE quantity per hour ==> to discharge need some robTIME
i need
specific TIME + robTIME ==> ETC expecting time of completition
spTIME HHmm ddMMYY +HHmm ==> ETC in format HHmm ddMMYY
for exemple
1800 021120 +2000 = 1400 031120
If you can get your hours value into the text box from your formula, this should work for you ...
add_hours.aia (4.2 KB)
I used List Pickers to set the hour and minute of the starting Instant, to avoid peculiarities of time conversion between Date Pickers and Time Pickers.
thanks for help
ill try
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.