LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hadleigh
 
Posts: n/a
Default Adding columns of times

I'm trying to add increments of time (in the h:mm format, for example 3:15),
to come up with the total hours and minutes in part of a column, in Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and
neither works properly. I've tried adjusting the format of the cell with the
formula in it. Still not working. Can anyone help? Thanks.
 
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
Adding columns in Pivot Table having common description sayvari Excel Worksheet Functions 2 April 12th 06 08:56 PM
adding three consecutive columns Darin Gibson Excel Worksheet Functions 1 November 22nd 05 08:50 PM
Pivot Table for 3 columns of elapsed times William Elerding Excel Discussion (Misc queries) 0 October 14th 05 06:44 AM
Adding Times Tony Excel Worksheet Functions 1 March 18th 05 03:07 AM
Adding quotes to columns Mj Excel Discussion (Misc queries) 3 December 9th 04 03:49 PM


All times are GMT +1. The time now is 05:41 AM.

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

About Us

"It's about Microsoft Excel"