Time Format (1 Viewer)

[thingssocomplex]

Hi All,

I have a Excel Extract that outputs time in to text entered in 24hr format for example 1445, 1145 1830 and so on. When this is placed in to Access is there a SQL Query I can write to convert to time format so I can correctly calculate a duration? I have tried Format(CDate(MyField),"hh:mm") but this just shows 00:00!!!

 

[JANR]

How about

Format(Timeserial(Left([MyField],2), Mid([MyField],3,2),0), "hh:mm")

JR

 

[thingssocomplex]

Thank you very much, amazing did the trick

 

[JANR]

When you know what to look for it's easy

JR