At iBE.net, we have always made it easy to download lists or tables to Excel with a single click. Now we are making it even easier by allowing all downloaded numbers to be automatically accessible in Excel for use in formulas by separating the value and units into separate columns.

To download durations as a number:

  • Open your user preferences
  • Navigate to the advanced tab
  • Click on “Show durations as decimals”. This changes duration fields in forms and lists on the screen to decimals of whatever is the most appropriate unit. For example, 1 h 30 m would change to 1.5 h when this box is checked. Since you download what you see, the same decimal number gets downloaded to excel