A B C
1 Start Time End Time Delta
2 8:00 10:20 =B2-A2

You'll then have to format the C column to have time in the format you want.

"Sandeep Manjrekar" wrote in
message ...
I have 2 rows - one has a start time and other has the end time. In the
third
row, i want to display the difference between two times. And it should
come
in this manner...

"4 hrs 15 min"..

what would be the exact formula?

Regards
sandeep