Time Formula?????
 

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 & 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: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=511047

Time Formula?????
 

The math is fine. Fix the formatting:


Instead of
h:mm
try
[h]:mm

this will allow the hours to get "large"
--
Gary''s Student


"Chris Watson" wrote:


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 & 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: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=511047

Time Formula?????
 

You need to use a custom number format of

[hh]:mm

The [] characters prevent Excel from "rolling over" at 24 hours.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chris Watson"
wrote
in message
...

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 & 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:
http://www.excelforum.com/member.php...fo&userid=4700
View this thread:
http://www.excelforum.com/showthread...hreadid=511047