Keep in mind that Excel doesn't know "time". It knows "numbers". Time is simply the "fractional part of a day"
9:30 is 0.395833333333333 of a day. 10:00 is 0.416666666666667 of a day. so, 9:30 - 10:00 is: -0.020833333333334 Now really, is 12/15/2010 -01:30 PM a valid time? Of course not... how can you have a NEGATIVE time of day? So, since you're DISPLAYING the cells in a TIME format, it produces an error with the negative result. If you don't CARE about the sign, then you can use: =ABS(A1-A2) and format it as "time" to get: 0:30 If you DO care about the sign, then you need to change the display format to a numeric format. Paul > >From: Bharghav Ramdas <bhargha...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wed, December 15, 2010 1:39:36 PM >Subject: $$Excel-Macros$$ Facing calculation issue using Time type in excel > > >Hi All, > >When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is ###.How >do >I go about resolving this issue.I require a positive number 0:30 inspite of >the >result turning out to be negative. > >FYI >=(1-2) > Current Expecting >1 9:30 9:30 >2 10:00 10:00 > #### 0:30 > >Let me know ur suggestions. > >Thanks, >Bharghav R-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
