subtract times
in [Programming]
|
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" <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 = 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" <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 = 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" <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 = B-A > > 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 = 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" <perjessen69(a)hotmail.com> 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" <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 = B-A > > thanks > mark
|
Pages: 1 Prev: Convert UTF-16 Unicode to UTF-8 Unicode? Next: Look up range and return value |