Solved: Initial Value of Duration Type Column - Page 2

MauriceWhelan · 08-31-2020 07:19 AM

Hi I am looking to set the Initial Value of a duration column called [Time Allotted]. The initial value formula would be based on the number of people selected in the [Resource] column. 1 person selected, [Time Allotted]= 2 hours, 2 people selected, [Time Allotted]=1 hour, 3 people selected, [Time Allotted] 30 mins etc…

Could anyone suggest how to address this problem?

Many thanks.

Maurice.

Steve

Perhaps something like:

CONCATENATE(
  FLOOR([minutes] / 60),
  ":",
  RIGHT(("00" & MOD([minutes], 60)), 2),
  ":00"
)

View solution in original post