software

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: www.excelforum.com/member.php...oamp;userid=29310
View this thread: www.excelforum.com/showthread...hreadid=511393Format 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

quot;cliffbellis766@quot;
lt;cliffbellis766.233224_1139691610.5702@excelforu m-nospam.comgt; wrote in
message news:cliffbellis766.233224_1139691610.5702@excelfo rum-nospam.com...
gt;
gt; Hi there - and HELP!!! with another probably simple thing, but spent
gt; ages looking for an answer to no avail.
gt; Have hours in cell A1 and minutes in cell A2 and looking for cell A3 to
gt; read total, but all readings are over the 24 hours. e.g:
gt;
gt; 32 hrs(A1) 30 min(A2) 32:30(A3)
gt;
gt; So far in A3 tried =SUM(TIME(A1,A2,0)) with A3 formatted as [h]:mm, and
gt; tried various other formats and formulas, but it still won't read over
gt; 24 hours. Also tried in A3 just =TIME(A1,A2,0).
gt; Am truly stuck.
gt; All the best
gt; Cliff
gt;
gt;
gt; --
gt; cliffbellis766@
gt; ------------------------------------------------------------------------
gt; cliffbellis766@'s Profile:
gt; www.excelforum.com/member.php...oamp;userid=29310
gt; View this thread: www.excelforum.com/showthread...hreadid=511393
gt;

I'm assuming you just have the numbers 32 and 30 in cells A1 and A2

try either

=(A1 A2/60)/24

or

=(A1amp;quot;:quot;amp;A2) 0

for either format as [h]:mm--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511393
Thankyou, thankyou, thankyou. And, er...thankyou.
Cliff--
cliffbellis766@
------------------------------------------------------------------------
cliffbellis766@'s Profile: www.excelforum.com/member.php...oamp;userid=29310
View this thread: www.excelforum.com/showthread...hreadid=511393