I've repeated this rant several times, but always willing to try do it again!
First of all, is your data an actual Excel "time" or a text string that "looks" like a "time" ?? To find out, try changing the format of the cell. if you're showing 20:22:16 and you change the cell format to h:mm:ss AM/PM does it change to 8:22:16 PM ?? If it does NOT, then you don't have a true Excel "time", you have a text string that LOOKS like a time. you can't do math with text!! Now, if it changes, then you have a true excel "time", and we can discuss that: Excel does not know anthing about "date" or "time". What it DOES know is the number of days and fractional part of days since 1/1/1900. So, tonight (9/3/2010) at 8:22:16 PM is 40424.8487962963 since midnight of 1/1/1900. So, when you do the subtrutions, you'll get the fractional part of a DAY, you just need to convert it to yours (24 hours/day) so, the difference 20:22:16 - 20:02:49 is equivalent to: 40,424.8487962963 - 40,424.8352893519 which is: is 19 minutes, 27 seconds, or 0.0135069444440887 days * 24 hours / day = 0.3241666667 hours does that help? Paul ________________________________ From: JohnA <johnasmit...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Thu, September 2, 2010 2:11:03 PM Subject: $$Excel-Macros$$ Formula for Military Time Calculations I need to determine time increments from postings in Excel in the 24 hour mode (commonly called military time). I can't come up with a formula to give me decimal hours from military time subtractions. Help please! JohnA -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
