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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Back
Top