I have a spreadsheet among the colums are two that work out flexi time
accrued in either a positive or negative quantity,the cells are
formatted as time, I have got it working to a point, but now I have 35
minutes in the negative column that I want to add 44 minutes to in
other words it should read + 9 minutes I have been using this formula
whichh has worked OK untill I try to take 35 from 44 and get a + 9 value
where cell n8 has the negative amount and m9 has the positive below is
the formula I have been using

=IF(TIMEVALUE(N70),TIMEVALUE(N8)-TIMEVALUE(M9))

M N
6 3:41
7 00:57 2:44
8 02:09 0:35
9 00:44 ?:??
10 00:48

TIA
Parlo

Hi Parlo,

See if you can find your answer by downloading this excel file and view the
Visual Basic macro inside the excel file.

Just cut and paste to internet address if no hyperlink:

http://www.planet-source-code.com/vb...46261&lngWId=1

"Parlo" wrote:

I have a spreadsheet among the colums are two that work out flexi time
accrued in either a positive or negative quantity,the cells are
formatted as time, I have got it working to a point, but now I have 35
minutes in the negative column that I want to add 44 minutes to in
other words it should read + 9 minutes I have been using this formula
whichh has worked OK untill I try to take 35 from 44 and get a + 9 value
where cell n8 has the negative amount and m9 has the positive below is
the formula I have been using

=IF(TIMEVALUE(N70),TIMEVALUE(N8)-TIMEVALUE(M9))

M N
6 3:41
7 00:57 2:44
8 02:09 0:35
9 00:44 ?:??
10 00:48

TIA
Parlo