Format the sum cell as [h]:mm or [hh]:mm (choose the one with 37:30:55).

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"cliffbellis766@"
<cliffbellis766.233224_1139691610.5702@excelforu m-nospam.com wrote in
message news:cliffbellis766.233224_1139691610.5702@excelfo rum-nospam.com...

Hi there - and HELP!!! with another probably simple thing, but spent
ages looking for an answer to no avail.
Have hours in cell A1 and minutes in cell A2 and looking for cell A3 to
read total, but all readings are over the 24 hours. e.g:

32 hrs(A1) 30 min(A2) 32:30(A3)

So far in A3 tried =SUM(TIME(A1,A2,0)) with A3 formatted as [h]:mm, and
tried various other formats and formulas, but it still won't read over
24 hours. Also tried in A3 just =TIME(A1,A2,0).
Am truly stuck.
All the best
Cliff


--
cliffbellis766@
------------------------------------------------------------------------
cliffbellis766@'s Profile:
http://www.excelforum.com/member.php...o&userid=29310
View this thread: http://www.excelforum.com/showthread...hreadid=511393