Calculating time differences with pre formatted cells

[kmahesh]

Hi experts,
here is my problem
First I want to enter time in hh:mm format but without entering ":" . For this I want to pre format the
cells and when I searched on the net I got this solution - format the cells with custom format 0\:00.
After doing this if i enter 1625 it is displayed as 16:25
So till here there is no problem.

But when I want to perform calculations on these cells say for example
A1 B1 C1=B1-A1
16:25 17:10 i should get 00:45

but its not working.

Any ideas ?

kmahesh

[:) Sixthsense :)]

In C1 Cell

=TEXT(B1,"00\:00")-TEXT(A1,"00\:00")

[kmahesh]

Thank U Sixthsense
Its working.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback