Sum Time
 

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

Sum Time
 

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

Sum Time
 

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

try either

=(A1+A2/60)/24

or

=(A1&":"&A2)+0

for either format as [h]:mm


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

Sum Time
 

Thankyou, thankyou, thankyou. And, er...thankyou.
Cliff


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