Hi there,

i am looking for a formula for the below prob:

27/10/12 06:10:00 subtract 27/10/12 06:12:00 = answer i want 00:12

---
i tried with =B1-A1
i tried with =TEXT(B1-A1,"h:mm:ss") but am getting #VALUE!

pls help

Thanks
Husso