Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |