What is the formula for getting time difference e.g. ("4 hrs 15 m.

[Sandeep Manjrekar]

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

 

[Barb Reinhardt]

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.

 

[Frank Kabel]

Hi
in which format do you have entere start/end time?

--
Regards
Frank Kabel
Frankfurt, Germany

"Sandeep Manjrekar" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...

 

[Jon Peltier]

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/
_______