this seems such an easy thing to do, so I am kinda embarrassed to ask. But I can’t find a solution here, neither could I solve it by myself, so your help is much appreciated.
I have 3 columns:
- “Today” = Checkbox
- “ET” (for expected time) = Duration in h:mm format
- “Planning” = Formula -> this is where the problem comes in
I want to add in Planning the ET value if Today is checked. IF(Today = 1,ET) does the trick.
But it gives out a numeric value. For example, 0:45 will be 2700 in Planning. Clearly I could divide by 60 to get the minute value but I want to format Planning in the same format h:mm than ET is. And I can’t get it done?!
Can anyone help?