Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sandeep Manjrekar
 
Posts: n/a
Default 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
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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



  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

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


  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"