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’.