Adding times in multile colums colums?

Platform discussions
,
1

Hello,

I have 5 Columns as follows

START, COOK, FINISH, COOL, DROP

I would like to be able to put a time in the start column and in the cook a cool columns is a value in minutes that the other 2 columns use to populate.

example,

START COOK FINISH COOL DROP
8:35 40 9:15 70 10:25

Can this be done at all?

Thanks!

2

Hey Garry,

I am checking in with our formula team internally about this, as I believe we could utilise the formula column to set those times based on the cook/cool times.

I will get back to you asap!

4

Thanks so much for your patience with me Garry - I apologise for the delay!

I have heard back from our formula team who advise the following:

image (157)
image (157)1150×290 10.7 KB

Finish formula: CONCATENATE(CONCATENATE(IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0) + {Start} + 0 > 12, ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0) + {Start} + 0 - 12, ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0) + {Start} + 0), ":"), TEXT(((RIGHT({Start}, 2) + {Cook}) / 60 - ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0)) * 60,"00")) & " " & IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0) + {Start} + 0 > 23, "AM", IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}) / 60, 0) + {Start} + 0 < 12, "AM", "PM"))

Drop formula:

CONCATENATE(CONCATENATE(IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0) + {Start} + 0 > 12, ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0) + {Start} + 0 - 12, ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0) + {Start} + 0), ":"), TEXT(((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60 - ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0)) * 60,"00")) & " " & IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0) + {Start} + 0 > 23, "AM", IF(ROUNDDOWN((RIGHT({Start}, 2) + {Cook}+ {Cool}) / 60, 0) + {Start} + 0 < 12, "AM", "PM"))

Let us know what you think!