Skip to main content

Help needed: Given a checkbox is checked, take value with time format

  • October 26, 2018
  • 2 replies
  • 51 views
C

Hey guys,

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. :slightly_smiling_face:

The Problem

I have 3 columns:

  1. “Today” = Checkbox
  2. “ET” (for expected time) = Duration in h:mm format
  3. “Planning” = Formula -> this is where the problem comes in :winking_face:

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?! :flushed:

Can anyone help?

Thanks!

cR

    This topic has been closed for replies.

    2 replies

    E
    Forum|alt.badge.img+17

    Check the Formatting tab on the field settings:

    Also, you can use simply IF(Today,ET).

      C
      • Christian_Roth
      • Author
      • New Participant
      • October 26, 2018

      @Elias_Gomez_Sainz OMG #lol I can’t believe I tried for an hour with this DATETIME_FORMAT command #facepalm - Sometimes solutions are so easy. Thanks for pointing me to the formatting tab :winking_face: Problem solved!
      cR

        Terms & ConditionsAccessibility statement