This number format shows 4:15 as 4 hrs 15 min:

h" hrs "m" min"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

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