Showing results for 
Search instead for 
Did you mean: 

Adding hhmm to a date

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

use below to convert string to date.

=todate([Date HHMM object];"hh:mm")