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;
- Nov 21 Wed 2007 20:40
Time Formula?????
close
全站熱搜
留言列表
發表留言