Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time
Can anyone help me calculate time. I simply want to add a column of minutes spent to determine total duration. -- Sandra ------------------------------------------------------------------------ Sandra's Profile: http://www.excelforum.com/member.php...o&userid=24115 View this thread: http://www.excelforum.com/showthread...hreadid=377186 |
#2
|
|||
|
|||
If you can give us more information on how your data is displayed and your desired output format, I'm sure someone can help you. How are your times listed in your column? hh:mm; mm:ss; hh:mm:ss, etc.? How do you want the sum of the times to be displayed... hh:mm, hh.n (e.g. 1.5 for 90 minutes)? Please give examples of your data and your expected results. -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=377186 |
#3
|
|||
|
|||
One way:
=SUM(A1:A1000) Format the cell with Format/Cells/Number/Custom [h]:mm or another time format. The brackets keep the value from rolling over (e.g., 25 hours will appear as 25:00 rather than 1:00). In article , Sandra wrote: Can anyone help me calculate time. I simply want to add a column of minutes spent to determine total duration. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |