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 = BA thanks mark
From: Joe User on 1 Apr 2010 18:52 "mp" <nospam(a)thanks.com> 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 = BA =(B2A2)*24 formatted as Number with some number of decimal places. Time and dates are stored as days and fraction of days.  original message  "mp" <nospam(a)thanks.com> 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 = BA > > thanks > mark >
From: Per Jessen on 1 Apr 2010 18:58 Hi Mark Use this formula: =MINUTE(B1A1)/60 and format the cell as general. Note: This formula will only work when BA <=60 Hopes this helps. .... Per On 2 Apr., 00:41, "mp" <nos...(a)thanks.com> 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 = BA > > thanks > mark
From: mp on 1 Apr 2010 19:33 "Joe User" <joeu2004> wrote in message news:uLWD23e0KHA.4832(a)TK2MSFTNGP04.phx.gbl... > "mp" <nospam(a)thanks.com> 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 = BA > > =(B2A2)*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" <perjessen69(a)hotmail.com> wrote in message news:6bba023fabd244768774bf57a9150138(a)8g2000yqz.googlegroups.com... Hi Mark Use this formula: =MINUTE(B1A1)/60 and format the cell as general. Note: This formula will only work when BA <=60 Hopes this helps. .... Per On 2 Apr., 00:41, "mp" <nos...(a)thanks.com> 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 = BA > > thanks > mark

Pages: 1 Prev: Convert UTF16 Unicode to UTF8 Unicode? Next: Look up range and return value 