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
0
12/3/2004 8:39:03 AM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
847 Views

Similar Articles

[PageSpeed] 51

         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


0
breinhardt (272)
12/3/2004 1:17:51 PM
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

0
frank.kabel (11126)
12/3/2004 1:19:36 PM
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
> 
> 
> 

0
12/4/2004 5:18:30 AM
Reply:

Similar Artilces:

How do I set up a daily average of unit sales formula
More info required. -- HTH RP (remove nothere from the email address if mailing direct) "jim m" <jim m@discussions.microsoft.com> wrote in message news:7E6D4510-97C1-42D4-A402-5590201C6065@microsoft.com... > ...

send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with one or two fields changed (for example the name of recipient and the date).How canthis be done?? I would also like to be able to save the e-mail and use it again and again. can anyone help cheers john If you have Word installed and it's the same version as Outlook (both 2003, for example), you can do a mail merge between the two. This would allow you to set up the text the way you want it to, and you can save the document for future use. Look at the following page for further information: http://www.slipstick.com/con...

Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other data. I want to save the workbook as another name with all the worksheets keeping the values only (no links or formulas). Is there a quick way to do this for everysheet without having to special paste every sheet in the workbook. So can I save everysheets data values at workbook level. See this page for a code example http://www.rondebruin.nl/values.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lex63" <lex63@discussions.microsoft.com> wrote in message news:ED708...

Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus, First of all, let me thank you in advance. I find it exemplary that you all can devote time to helping others who are having issues with their work. Hopefully one day I can be at a mentor level, and help others too. Hope you can help! I have an issue where I don't know how to write the formula that I need without going over on the nesting. The current formula that I have is as follows: =IF(OR(B7="",J7="",L7="",M7="",N7="",O7="",P7=""),"No Data",IF(V7="Yes",&qu...

Time Series
I have about 30000 lines of data that looks like so: Time Count 93000 447 93001 1020 93002 1438 93003 2177 93004 3042 93005 3467 93006 2913 93007 3341 93008 3547 93009 2908 93010 3512 93011 4090 Where ColA is time. I am having trouble creating a graph with time on the x-axis and count on the y-axis. Thank you in advance. You need to make an XY chart But with 30,000 data points you could run into trouble; Help says you can 32,000 data points in a single data series. However, if you want markers it will look like heck. You could limit the data like this: assume y-values in B2:B30001 in ...

How can I get 32-bit Integers?
I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type is just 16 bits, i.e. its max value is 32,767. How can I configure it so as to have 32-bit Integers, along with 64-bit Longs? "Renny Bosch" <noname@nospam.com> wrote in message news:OqqNyqmuKHA.4492@TK2MSFTNGP05.phx.gbl... > I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type > is just 16 bits, i.e. its max value is 32,767. How can I configure it so > as to have 32-bit Integers, along with 64-bit Longs? An Access Integer is 16 bits. A Long Integer is...

Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail. If I close Excel and retry it will open Excel and the spreadsheet. Any ideas? I hate having to close all my open spreadsheets when I want to open a spreadsheet that's been e-mailed to me! One of these usually works with a similar problem starting workbooks by double clicking them in Windows Explorer. Maybe one will work for you and your email problem. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close E...

Mysterious e-mails
i keep getting e-mails that look and appear that they have come from people either in my phone book or in some cases from people that have ligitimately e-mailed me or that I have e-mailed. In fact the e-mail has come from somewhere else even though the sender appears to be ligitimate. Most of these e-mails are dated 3 or four weeks old and show that they have been read in my inbox. I've asked a few people if they have forwarded the mail to me but they havn't. Most e-mails are selling Viagra or some other product. ??? any clue ??? Thanks in advance You're being spammed. First...

INTERNET MILLION DOLLARS
INTERNET MILLION DOLLARS - www.InternetMillionDollars.biz Watch the VIDEO on YOUTUBE... NOW! http://www.youtube.com/watch?v=dXQUjk5EGV0 MAKE MONEY INSTANTLY using 2007 featured INTERNET MILLION DOLLARS as a resource. WORK FROM HOME HOMEBASED JOBS AND IDEAS BUSINESS OPPORTUNITY Professor James Bradley's "Quick and real way to make BIG MONEY on the Internet!" The Independent Finally you have FOUND IT! Make a FORTUNE each month... .... every month! 100% ON AUTOPILOT Read it NOW and CHANGE YOUR LIFE! Are you fed up with being short of MONEY all the time? Do you DREAM about a...

How do I get Powerpoint 2003 fade in 1 by 1 in 2007
I frequently used the 'fade in one by one' feature in Powerpoint 2003, which allowed me to fade in individual bullet points by way of a click of a mouse. Not only is this feature now not standard in 2007, but I can't work out how to create it: anything that I find, tends, instead, to fade the bullet points in on some kind of automatic time schedule, rather than - as I want - on a mouse click. I want only to use text, no sounds, no pictures, and nothing fancy. Currently, I am reduced to copying my material into an old Powerpoint 2003 presentation, but this is silly....

product key #4
I have a product key for microsoft office which I purchased for my pc several months back. I am now trying to use that same product key to register office on my mac (office was pre-installed). Where do I enter in this product key in the mac office trial software in order for me to get full access? In article <1190872643.026720.79220@w3g2000hsg.googlegroups.com>, jaime825@gmail.com wrote: > I have a product key for microsoft office which I purchased for my pc > several months back. I am now trying to use that same product key to > register office on my mac (office was pre...

Congratulations! This has been a MEB-free newsgroup for 4 weeks.
We all deserve a pat on the back. This has been a MEB-free workplace for over 4 weeks - practically the entire month of June. As Microsoft turns off it's usenet server and removes this newsgroup from it's server, we have seen the last of Maurice Edward Brahier and as this group continues to exist outside of Microsoft we will never again see him post to this group. The fact that he has been a fraud and not a real user of Windows 98 for many months if not years probably has something to do with that. His incoherent and rambling posts, written in a particularly obtuse form ...

Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to separate the text into 2 cells - one with the date and the other with the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks for your help Sameer --- Message posted from http://www.ExcelForum.com/ For the date use =INT(A1) replace A1 with the first cell of your range for time =MOD(A1,1) you probably have to reformat the first to mm/dd/yy (or whatever the setting is) and hh:mm Note that you can do this by just using format but if you want to compare to other cells with just pure d...

getting started
I'm installing office 2003, outlook, I'm lost from server type to URL address to server info? I have sbc yahoo dsl. can you help me? damselindistress <damselindistress@discussions.microsoft.com> wrote: > I'm installing office 2003, outlook, I'm lost from server type to URL > address to server info? I have sbc yahoo dsl. can you help me? When you obtained your packet from SBC, they included all that information. Moreover, it's in the Help section of SBC Yahoo's site. The most likely settings are "pop.sbcglobal.yahoo.com" for the incoming serv...

Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this: =IF($G21<>"",($H20-$G21),"") is there a way to adjust the formula so that an empty cell in G21 doesn't give the #VALUE! in subsequent cells in column H? Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for any and all empty cells in A2 to A9. It no longer matters if any of the cells are empty, the formula correctly gives the correct addition of A1 plust a sum of everything between A2 to A10 without any #VALUE! results. Was hoping to have the formula above als...

how do you get a landscape page?
Please help, desperate! If you are using 2010, Page Design tab, Size, More pre-set page sizes. Letter landscape is the first choice. In all other Publisher versions landscape will be on the page setup screen found in the File menu. -- Mary Sauer http://msauer.mvps.org/ "becky.x" <becky.x@discussions.microsoft.com> wrote in message news:25D3EDBC-93EF-4582-94B2-83C9CE121E17@microsoft.com... > Please help, desperate! ...

Help With Margin Formula
Hello, I need help with a margin forumla (calculated from retail). Say I have a cost of $10.00, and I need the formula to calculate a 40% margin from retail. So the retail should end up at $16.67. Not sure how to get from $10.00 to $16.66, I just know the cost and the margin I need to make. Thanks JR =A1/(100%-40%) -- Kind regards, Niek Otten "JR" <gaspower@aol.com> wrote in message news:eGszf.424$2O6.53@newssvr12.news.prodigy.com... > Hello, > I need help with a margin forumla (calculated from retail). Say I have a > cost of $10.00, and I need the formul...

Run time error 5 : HQClient
When I double click HQ Client I have message box "Run time error 5 : Invalid procedure call or argument" how should I do? I used RMS 2.0 -- TOY2TOY ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGr...

Removing spaces from text #4
I'm in excel and i have a bunch of text data that has an extra space at the end of the text on the right hand side for each cell. Is there any easy way to remove this space? Use the TRIM() function. -- Kind regards, Niek Otten "lj" <lj@spu.edu> wrote in message news:1144876429.220961.309040@j33g2000cwa.googlegroups.com... > I'm in excel and i have a bunch of text data that has an extra space at > the end of the text on the right hand side for each cell. Is there any > easy way to remove this space? > I tried using that function but the results st...

Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display the time increments in 15 minute blocks, but on the Appointments form, the Start and End Times available on the drop-down menus, respectively, are in 30 minute increment blocks only. How can I set the format for the appointment page to have the Start and End Times for appointments have increment time blocks of 15 minutes? Thanks! My direct email address is: solutioncounselor@comcast.net . If you set your appointments in 15 minute blocks Outlook will start to offer that. It takes a few uses to work. -- Nikki Peterson [MVP ...

Status Bar #4
Hi - can anyone tell me what the "official" name is for the facility on the Excel Status Bar which allows you to select a range of cells and view the Sum, Average etc of those cells? Thanks. It's the AutoCalculate feature: AutoCalculate feature is working even if that feature is turned off http://support.microsoft.com/default.aspx?id=325703 XL7: CTRL+Click Selected Cell Changes AutoCalculate Value http://support.microsoft.com/default.aspx?id=133050 Alex wrote: > Hi - can anyone tell me what the "official" name is for the facility on the > Excel St...

how to know how many e-mail each user receives per day?
We are running Exchange 2003 on Windows 2003. I would like to know how to get an average of how many e-mails each users send and receives per day. ...

OLE Notes #4
Windows Server 2000 SP4 MS SQL Server 2000 SP4 MS Dynamics 9.0 SP3 When a note is entered on a vendor card (Cards, Purchasing, Vendor, Note icon) a dialog box titled OLE Pathname appears. The purpose is a shared notes location. If the user clicks ok or cancel without entering a path, where is the note stored? I have two vendors that have the exact same note, entered at the exact same time, by the same user. In theory this should not be possible. The OLE path is not specified in the dex.ini file. -- Thanks Titan Did you not find the note in SY03900 table on the company? The vendor c...

Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values in a range. Example: Column A may have five cells that are "4", five cells that are "7", five cells that are "9". Of the fifteen cells that contain data, there are only 3 different values. I'd like to use a formula that will count the number of different values in column A, in this case the result is "3". Thanks, Paul Try... =SUMPRODUCT((A1:A15<>"")/COUNTIF(A1:A15,A1:A15&"")) OR =SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...

Auto Delete the e-mail
Hi all We are using Microsoft Exchange 2003 and Outlook 2003. One mail box calls "Sales", i configured the achieve function for this mail box, this function will automatically delete mail if the mail is order than 7 days. But this function is not running if the outlook closed, is it possible this function running on server only, no need to open Microsoft Outlook for running the achieve function in client PC ? Philip In news:uApBq0j8FHA.2800@TK2MSFTNGP10.phx.gbl, Philip Tsang <philip@sib-infotech.com> typed: > Hi all > > We are using Microsoft Exchange 2003...