Need help datetime+hours

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:
195b2fd621629011f5df9410b9ae2944b3f3977e_2_690x192

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.

1 Like

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)

Capture

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

Japanese subway simulation working
solver >>>>Text can never hold an Instant:

Thanks

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.