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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks