Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html
b.. http://xldynamic.com/source/xld.SUMPRODUCT.html
--
David Biddulph

"Neeraj Gupta" wrote in message
...
On Aug 13, 4:29 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
The simple way of converting the 0040 to a time of 00:40 is to use
=--TEXT(A1,"00\:00") and format the cell as time.
--
David Biddulph


Hi David ,

In the above formula what are these 2 dashes for...."=--TEXT"

Regards
Neeraj