Adding hours, minutes and seconds to a date field

Requirement: Adding 10 hours 10 minutes to a date field.

Example: Adding 10 hours 10 minutes to Activity ‘Start’ (date field).

Solution: The process consists of following three steps.

 

1. Convert the time, which you want to add into hours per day.

i.e. 10 hours 10 minutes = 10/24 + (10/24*60)

2. Go to Action BC, create a calculated field ‘Calc Planned1’ as shown below.

Here I am adding 10 hours 10 minutes to the field ‘Planned’.

3. Expose these two fields to the UI