on 2019 Sep 20 8:45 PM
1. Convert hhmm to hh:mm (should be a time format)
2. Need a working formula to add hhmm(string) to a date(string) - DateTime1 variable
2. Add additional time(like 4, 5, 8 hours) to DateTime1 variable
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use below to convert string to date.
=todate([Date HHMM object];"hh:mm")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.