Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
What is the formula for getting time difference e.g. ("4 hrs 15 m.
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
What is the formula for getting time difference e.g. ("4 hrs 15 m.
 |
What is the formula for getting time difference e.g. ("4 hrs 15 m. |
|
|
Thread Tools | Rate Thread |
03-12-2004, 08:39 AM
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
03-12-2004, 01:17 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: What is the formula for getting time difference e.g. ("4 hrs 15 m.
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" <SandeepManjrekar@discussions.microsoft.com> wrote in message news:3AA54934-E119-46AE-8822-E947F94E873B@microsoft.com... > 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 |
|
|
|
03-12-2004, 01:19 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: What is the formula for getting time difference e.g. ("4 hrs 15 m.
Hi
in which format do you have entere start/end time? -- Regards Frank Kabel Frankfurt, Germany "Sandeep Manjrekar" <SandeepManjrekar@discussions.microsoft.com> schrieb im Newsbeitrag news:3AA54934-E119-46AE-8822-E947F94E873B@microsoft.com... > 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 |
|
|
|
04-12-2004, 05:18 AM
|
#4 |
|
Guest
Posts: n/a
|
Re: What is the formula for getting time difference e.g. ("4 hrs15 m.
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" <SandeepManjrekar@discussions.microsoft.com> wrote in > message news:3AA54934-E119-46AE-8822-E947F94E873B@microsoft.com... > >>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 > > > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
