From: mp on 1 Apr 2010 18:41 How to get time difference in hours and fractions of hours? example 3 columns in a spread sheet Col A and B formated as "Time" Col C formatted as Custom "h:mm" produces result 0:20 in example below how to format so as to produce result 0.3333? I tried formatting as "h" but it then produces 0 formatting as 0.00 produces 0.01 - no clue how it comes up with that one? Col A Col B Col C Start Time End Time Elapsed 2:50 PM 3:10 PM = B-A thanks mark From: Joe User on 1 Apr 2010 18:52 "mp" wrote:> How to get time difference in hours and fractions of hours? [....]> Col A Col B Col C > Start Time End Time Elapsed > 2:50 PM 3:10 PM = B-A =(B2-A2)*24 formatted as Number with some number of decimal places. Time and dates are stored as days and fraction of days. ----- original message ----- "mp" wrote in message news:uxJl6xe0KHA.224(a)TK2MSFTNGP06.phx.gbl...> > How to get time difference in hours and fractions of hours? > > example 3 columns in a spread sheet > Col A and B formated as "Time" > Col C formatted as Custom "h:mm" produces result 0:20 in example below > how to format so as to produce result 0.3333? > I tried formatting as "h" but it then produces 0 > formatting as 0.00 produces 0.01 - no clue how it comes up with that one? > > Col A Col B Col C > Start Time End Time Elapsed > 2:50 PM 3:10 PM = B-A > > thanks > mark > From: Per Jessen on 1 Apr 2010 18:58 Hi Mark Use this formula: =MINUTE(B1-A1)/60 and format the cell as general. Note: This formula will only work when B-A <=60 Hopes this helps. .... Per On 2 Apr., 00:41, "mp" wrote:> How to get time difference in hours and fractions of hours? > > example 3 columns in a spread sheet > Col A and B formated as "Time" > Col C formatted as Custom "h:mm" produces result 0:20 in example below > how to format so as to produce result 0.3333? > I tried formatting as "h" but it then produces 0 > formatting as 0.00 produces 0.01 - no clue how it comes up with that one? > > Col A                Col B            Col C > Start Time        End Time        Elapsed > 2:50 PM           3:10 PM        = B-A > > thanks > mark From: mp on 1 Apr 2010 19:33 "Joe User" wrote in message news:uLWD23e0KHA.4832(a)TK2MSFTNGP04.phx.gbl...> "mp" wrote: >> How to get time difference in hours and fractions of hours? > [....] >> Col A Col B Col C >> Start Time End Time Elapsed >> 2:50 PM 3:10 PM = B-A > > =(B2-A2)*24 > > formatted as Number with some number of decimal places. > > Time and dates are stored as days and fraction of days. > > Thanks much! that works mark From: mp on 1 Apr 2010 19:34 Thanks Per Joe's also worked and should work for any amt, not just <60 "Per Jessen" wrote in message news:6bba023f-abd2-4476-8774-bf57a9150138(a)8g2000yqz.googlegroups.com... Hi Mark Use this formula: =MINUTE(B1-A1)/60 and format the cell as general. Note: This formula will only work when B-A <=60 Hopes this helps. .... Per On 2 Apr., 00:41, "mp" wrote:> How to get time difference in hours and fractions of hours? > > example 3 columns in a spread sheet > Col A and B formated as "Time" > Col C formatted as Custom "h:mm" produces result 0:20 in example below > how to format so as to produce result 0.3333? > I tried formatting as "h" but it then produces 0 > formatting as 0.00 produces 0.01 - no clue how it comes up with that one? > > Col A Col B Col C > Start Time End Time Elapsed > 2:50 PM 3:10 PM = B-A > > thanks > mark  |  Pages: 1 Prev: Convert UTF-16 Unicode to UTF-8 Unicode?Next: Look up range and return value