Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Convert negative decimal numbers to time (Long Time)

I'm trying to convert negative decimal numbers to a time displayed as hh:nn:ss (Long Time), however, it's giving me an error: Instead of converting the "Verschil" column, I also tried to calcu...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Dates and Times can only ever be positive. What does your column represent?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The "Verschil" column represents the difference in time between "Gepland" and "Aantal"

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Then you need to treat it as a duration data type, not a datetime data type. Not sure if negative durations are supported.