Unveiling the Potential: Altering Time Formats with the Advanced Formula Editor

[Richard_Sather]

Great post @Tetsuo_Kawakami , I’ll be testing all these out!

Indeed, @Bastien_Siebman ! I’d like to also link the following relevant posts to this thread too, for reference:

Formula custom field with Advanced Editor

FYI I just found that we can display actual time in hours unit at dashboard # chart. [image] [image] just define for it in advanced editor below; [image]

Number formatting of "estimated time" in charts in hours instead of days

Note: Not a solution but marked as such to elevate a key reply For all Business & Enterprise users (who have the latest Advanced Editor for Formulas which is currently rolling out), there is a workaround for you! [image] For all your projects that you are using Asana’s native Estimated or Actual hours fields, do the following for either field: The examples below are for Estimated time, but you can follow exactly the same for Actual time field also. To get results in hh:mm C…