Date and time subtraction in excel 2003

[hu2sain]

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

[dogberry]

Hi

Looking at the above you are subtracting 06:12 from 06:10 as both dates are the same which would give you a negative value. I have never used 2003 so I dont know what capabilites you have. Try posting a sample. The cell you have the formula in have you changed that from general to time.

Hope that helps

Chris

[BeachRock]

Hi Husso,

Format the cells with custom and a Type of dd/mm/yy - hh:mm:ss. Then use B1-A1.

[hu2sain]

No luck! still getting #VALUE! even after changing the format of the cell...

[Pepe Le Mokko]

Hi there,



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


Thanks
Husso

How do you get 12 min when sutracting 10 from 12 ? B1-A1 should do the trick ( giving 02:00) . If not there is something we cannot see
Please post a sample sheet

@Beachrock : formatting does not change the underlying value and is of no consequence on the outcome

[hu2sain]

oopss sorry typo error i just wanna subtract...

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

FYI: i have attached the sample.

Thanks

Husso

[oeldere]

i changed the format of the (green) cell.

see the attached file.

[Kevin UK]

Assuming your data is in A1 & B1:
How about:

Please Login or Register  to view this content.

[hu2sain]

Thank u Oeldere but i am not able to apply pls check the same excel although the format are same
please let me know what is wrong
thanks in advance.