Problem with time format

  • Thread starter Thread starter n.kennedy927
  • Start date Start date
N

n.kennedy927

Hi folks

I have a report which, when exporting, has three colums - one shows an
original allowance, column 2 shows debits against this, column 3 shows
the net balance.

Unfortunately, as this report exports as text not values, it shows a
negative value for a time.

How can I convert this negative time into a positive figure for use
for calculations (I need to be able to put it somewhere else for
calculation purposes) - it must be done within the formula or via
formatting. I have tried the following in a bewildering array of
formulas and conjunctions without any luck at all - ABS / CONVERT /
VALUE (the VALUE function works just fine for the figure in the
Allowance column, and also where the Balance figure is a positive
number.)

Small example:-

Allowance Debits Balance
25/02/2008 98:00 - 107:30 - 9:30

26/02/2008 98:00 - 83:00 15:00

Any help / advice / pointer will be greatly appreciated

Cheers muchly in advance

Neil Kennedy
 
Just to advise, I have now managed to sort this (quick addition to the
copy / paste macro to remove the negative sign with a good old
fashioned find / replace)
 
Back
Top