What format is needed to import time into a BoM? The format it exports out as, does not match up with the import. For example if you export a BoM you would get something like: 1 d 09 h 07 m
If you attempt to import that, you won’t get the same result. Anyone know how we should be importing these?
Solved
BoM Time Format Imports
+2Best answer by Michaelh
I found the answer: The system will take an integer value in MINUTES, so clever use of find() and/or left() and right() in Excel can get you where you need to be. If there is an easier method, please let me know!
+2I found the answer: The system will take an integer value in MINUTES, so clever use of find() and/or left() and right() in Excel can get you where you need to be. If there is an easier method, please let me know!
Permanent Newb, don't let the posts fool you.
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.