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 |
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 |