Export To Excel Sheet With Special Command

[Seikyo]

Is it possible to extract the numeric out as a separate field after export to
excel sheet had been done?

For example,

11 hrs 30 mins
OR
123 hrs 30 mins

Is it possible to get the 11 as a field and 30 as another field or 123 as a
field and 30 as another fields?

 

[David Seeto via AccessMonster.com]

Um, you can certainly split the field apart, but what do you mean "after
you export it to Excel"? Does that mean you'd like to split the resulting
Excel column into its numeric components? If so, I'd say you'd be better
off asking around in the Excel forums.

You could split the fields before you export it to Excel, though, which is
something we could have a look at here...