Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
glider pilot
 
Posts: n/a
Default 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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 04:45 PM
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 10:49 AM
Problems calculating total hours LolaK Excel Discussion (Misc queries) 1 December 14th 04 05:23 PM
calculate average hours and minutes llstephens Excel Worksheet Functions 4 November 30th 04 04:47 PM
Subtracting paid hours from unpaid hours ejerry7 Excel Worksheet Functions 5 November 29th 04 05:16 AM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"