UD field definition

Yahoo Archive
1
Perfect!   Thank you.
2

I have a numeric UD field that is being used to store time, HHMM.   When I try to extract the field into a BAQ or into Excel, it pulls out something completely different than what is displayed on the screen.    On the screen I see it as 07:52 but when I pull it out I see 28320.0000 in Excel.    This UD field is numeric so I cannot pull it out as HHMM.   


How can I interpret this correctly?


Thanks,


Pat

3
Seconds after midnight

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 09, 2015 11:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UD field definition



I have a numeric UD field that is being used to store time, HHMM. When I try to extract the field into a BAQ or into Excel, it pulls out something completely different than what is displayed on the screen. On the screen I see it as 07:52 but when I pull it out I see 28320.0000 in Excel. This UD field is numeric so I cannot pull it out as HHMM.



How can I interpret this correctly?



Thanks,



Pat



[Non-text portions of this message have been removed]