Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
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
Icon for Super User rankSuper 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.