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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Sandeep Manjrekar"
schrieb im Newsbeitrag
...
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

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