Convert original Estimate to days in formula in structure

Sanjivani Wayal

I Have this field Original estimate in Duration Format like 27m i want to use it in calculation to add it with field which has Days or number format how can i convert the original estimate into day or number and use it 

with _Estimate = (IF originalestimate :
(originalestimate)
Else :
(presaleestimate) ):

_Estimate - presaleEstimate

 

Where original estimate is time/duration format and presale estimate is day (number ) format

Valerie Knapp_dpp5c6

Hi @Sanjivani Wayal , thanks for your question.

Have you thought about contacting the support for Structure? I think they might be the best placed to help you understand how to construct the data / query that you want.

Formulas Basics (almworks.com)

Send Feedback (almworks.com)