Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Convert Military time to a float number

Highlighted
8 - Asteroid

Hi Everyone,

This may sound like an odd question but can someone tell me how I can convert military time (24 hour time) to a float number?

 

So for instance 5:15pm which I've converted to 17:15 already, can I convert that 17:15 string to 17.30 float number?

Highlighted
Alteryx Certified Partner

Hi @ISUGraber 

 

Like this?

jrgo_0-1572545446556.png

 

TONUMBER(REPLACE([Field1], ':', '.'))

 

Highlighted
17 - Castor
17 - Castor

Hi @ISUGraber 

 

You use this formula to convert to decimal(float) time

 

[hour]+[minutes]/60

 

Giving

r.png

 

Dan

Labels