First please removed the date stamp with your time ( "1/1/1900") default time stamped on your column e. if you have those in column b, remove them as well
Then just use simple formula of =c3-d3 + (d3-b3). it should give you correct number of hours. ernie On Mon, Feb 22, 2010 at 1:31 PM, Dave Bonallack <davebonall...@hotmail.com>wrote: > Hi, > Try this formula: > =(D3-B3+MOD(E3,INT(E3))-C3)*24 > Also, see attached sheet. > Regards - Dave. > > ------------------------------ > Date: Sun, 21 Feb 2010 19:24:25 -0800 > From: akash4...@yahoo.com > > Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations > To: goswami.ros...@gmail.com; excel-macros@googlegroups.com > > > Dear Rohan, > > I have tried that formula. Its fine for normal calculations. But its not > showing correct result when my activity starts on say Monday afternoon 12:00 > Hrs and It goes upto Tuesday Afternoon 15:00 Hrs, Total Time shown should be > (12 Hrs for Monday + 15 Hrs for Tuesday) i.e 27:00 Hrs in Total based on > data available > > --- On *Sun, 2/21/10, roshan <goswami.ros...@gmail.com>* wrote: > > > From: roshan <goswami.ros...@gmail.com> > Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations > To: akash4...@yahoo.com > Date: Sunday, February 21, 2010, 8:33 PM > > hello > > change the format form time as how i did in my sheet and substract > > On Sun, Feb 21, 2010 at 12:31 AM, Akash $urkatha > <akash4...@yahoo.com<http://us.mc527.mail.yahoo.com/mc/compose?to=akash4...@yahoo.com> > > wrote: > > Dear all, > > Attached is the sheet containing some Start Date, Start Time on the same > Day and End Day, End Time of a particular activity. All viz. Start Date, > Start Time, End Day, End Time are mentioned in the separate columns. > > Looking at the available data, I would appreciate if I can get help from > you guys to - get me the difference in Time (Hours). > > As for instance, if my start day is 17-Feb-2010, Start Time is 12:00 Hrs, > End Date - 18-Feb-2010, End Time is 15:00 Hrs, Hence, the formula required > should be able to return Total Hrs as 27:00 Hrs in the succeeding column. > > Other option is to write date with Time in specified manner and directly > deducting the same but the data available with me is as per the attached > sheet and hence shall require more time to bring to that format. So, please > consider as per attachment. > > Request you to please give your feedback on the same. > > With Regards, > > Aakash > Sky Constructions Ltd, > Mumbai. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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<http://us.mc527.mail.yahoo.com/mc/compose?to=excel-mac...@googlegroups.com> > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > ------------------------------ > Learn how Video chat with Windows Live > Messenger<http://windowslive.ninemsn.com.au/messenger/article/870686/video-chat-with-messenger> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
