Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add column of minutes, show total in hours & minutes
How do I add up a column of minutes showed for each flight and express the
total in hours and minutes? |
#2
|
|||
|
|||
=SUM(A2:A25)/1440
format as [hh]:mm Regards, Peo Sjoblom "glider pilot" wrote: How do I add up a column of minutes showed for each flight and express the total in hours and minutes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
hide column but show chart | Charts and Charting in Excel | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |