This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve got a datetime field called Start time (UTC)
I want to take the time component and reformat the minutes into a fraction.
For example:
SourceDesired output14:001414:1514.2514:3014.514:5514.92
I have tried taking the minute component and conditio...
This is great, thank you - VALUE was what I needed.
This is the formula I ended up with :
DATETIME_FORMAT({Start time (UTC)},'H') & IF(VALUE(DATETIME_FORMAT({Start time (UTC)},'m'))/60=0,'', SUBSTITUTE(VALUE(DATETIME_FORMAT({Start time (UTC)},'m'))/6...
