My MS-Excel sheet contains two columns (A and B) with hours.
The format of these columns in Excel is: [u]:mm. The Excelformulabar shows ‘8-1-1900 17:00:00’ and the ‘translation’ to the particular cell is: 406:00
Now I would like to import this sheet in BusObj (6.5) with the right dataset,
what enables me to make a calculation between hourcolumn A - hourcolumn B
For example:
column A contains : 406:00 column B contains: 399:00 calculated field C shows 007:00
Hey I know the problem you are facing actually you now need to format the cell and make it 0.This will definelty work.
Right Click on that column ,click on Number Tab and then All (on the left side) and choose o.
keep me posted.
Using BO 5.1.6 it will force a date format on both time objects when imported in BO. Does that happen in BO 6.5 aswell?
If so, you might want to add two columns in your excel sheet without the [u]:mm format or an extra sheet which is linked to the orignal. In this second tab discard the time format, which will leave you with the numerical value of both objects. This you can consequently import in BO to calculate the time value of the objects and the difference between the two.
You can also try the macro in the FAQ submitted by Anita and Dave which will enable you to override the format BO uses to import data from excel.
After some days I found a way how to calculate with the Excel-hours
Enclosed you will find the sample Excel-file.
After importing this file into BusObj you can make your own computation with the hours you need. You can’t make use of the original Excel-hournotation. BOBhour.xls (130.0 KB)