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