Excellent explanation..... and to me too, 3:48 is NOT equivalent to 3.48 hours.
Well Done Paul On Fri, Oct 15, 2010 at 5:42 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > just so you know: > > 3 hours 48 minutes is NOT 3.48 hours. > > it's 3.8 hours... > > If you're wanting the hours/minutes expressed as a decimal: > > =A1*24 > > > That is: if your time (3:48) is an actual Excel TIME and not a text > string. > > Keep in mind that Excel doesn't store "date" and "time" > > it is a number that represents the number of days and fractions of days > since 1/1/1900. > > So, today (10/15/2010) at 3:48 am in Excel is: > > 40466.1583333333 > > but you can change how excel DISPLAYS this number. > > You can choose to DISPLAY it as a date, or just the hour > > or, using the format Cells -> Number tab, Custom, > > changing it to: > mm.dd.yyyy hh.mm.ss > > will display 10.15.2010 03.48.00 > > ------------------------- > it all depends on what you're trying to do with this conversion. > > If you're trying to display 3:48 as an hour and fraction of hour, > and then you choose to add 4.12 and hope to get 8.0 > It's not going to happen if you CHANGE the time to 3.48 instead of 3.8 > > Now, if you change the DISPLAY FORMAT, excel will still understand > that 48 minutes + 12 minutes = 1 hour and do the math properly. > > I think this is a case where someone has posted a question without > giving the context. > There's been a couple of answers posted that answer the QUESTION, > but the answers require an ASSUMPTION on our part of what is your INTENT. > > You ASKED how you could write "time in decimal format". > But the example you gave is NOT what I would consider the decimal format of > time. > because to ME, 3:48 is NOT the equivalent of 3.48 > > Take a look at the answers you've been given and see if they help you > toward the results you require... > > Paul > > > > > *From:* Vijay Kr. Aggarwal <vjaggarwal2...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Thu, October 14, 2010 11:55:42 PM > *Subject:* $$Excel-Macros$$ Time in Decimal format > > Hi Friends, > > Please let me know that how can I write time in decimal format. > > Time :- 3:48 (3 hours 48 mins) then it should show 3.48 > > Thanks in advance > > Regards, > Vijay > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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