close

want to add up time eg:Cell A1(13:00) Cell A2(13:00) = Cell A3(26:00),
If I put in A3 the formula: =A1 A2 it works fine but if A1 amp; A2 are the
result of a formula from several other Cells eg:
B1(03:00) B2(06:00) B3(04:00) the result is 02:00 in Cell A3, I know
this is due to the 24 Hour clock but how can I get round it, I have
tried every time format and just get numbers. I have been on this
problem for hours now and its driving me mad, Please can somebody
help!!--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: www.excelforum.com/member.php...foamp;userid=4700
View this thread: www.excelforum.com/showthread...hreadid=511047The math is fine. Fix the formatting:Instead of
h:mm
try
[h]:mm

this will allow the hours to get quot;largequot;
--
Gary''s Studentquot;Chris Watsonquot; wrote:

gt;
gt; want to add up time eg:Cell A1(13:00) Cell A2(13:00) = Cell A3(26:00),
gt; If I put in A3 the formula: =A1 A2 it works fine but if A1 amp; A2 are the
gt; result of a formula from several other Cells eg:
gt; B1(03:00) B2(06:00) B3(04:00) the result is 02:00 in Cell A3, I know
gt; this is due to the 24 Hour clock but how can I get round it, I have
gt; tried every time format and just get numbers. I have been on this
gt; problem for hours now and its driving me mad, Please can somebody
gt; help!!
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile: www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread: www.excelforum.com/showthread...hreadid=511047
gt;
gt;

You need to use a custom number format of

[hh]:mm

The [] characters prevent Excel from quot;rolling overquot; at 24 hours.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Chris Watsonquot;
gt; wrote
in message
...
gt;
gt; want to add up time eg:Cell A1(13:00) Cell A2(13:00) = Cell
gt; A3(26:00),
gt; If I put in A3 the formula: =A1 A2 it works fine but if A1 amp; A2
gt; are the
gt; result of a formula from several other Cells eg:
gt; B1(03:00) B2(06:00) B3(04:00) the result is 02:00 in Cell A3, I
gt; know
gt; this is due to the 24 Hour clock but how can I get round it, I
gt; have
gt; tried every time format and just get numbers. I have been on
gt; this
gt; problem for hours now and its driving me mad, Please can
gt; somebody
gt; help!!
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile:
gt; www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=511047
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()