Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SGT Banuelos
 
Posts: n/a
Default I need help with a formula!

Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!

  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

SGT,

in cell B6, array enter (enter using Ctrl-Shift-Enter) the formula

=SUM(VALUE(LEFT(B4:B5,FIND(":",B4:B5)-1)))&":"&SUM(VALUE(MID(B4:B5,FIND(":",B4:B5)+1,15) ))

All that should be on one line. Then copy and paste to C6.

HTH,
Bernie
MS Excel MVP

"SGT Banuelos" <SGT wrote in message
...
Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!



  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

Ordinarily, Excel applies the same format to the cell with the SUM formula as
the cells being summed. What is happening in your case?


On Tue, 16 Nov 2004 17:33:02 -0800, SGT Banuelos <SGT
wrote:

Well, I am trying to add cells B4-B11. My #'s in each cell look like this
"1:1"! How do I get the sum of these cells to also look like that?

For example,
B C
4 1:0 0:2
5 0:1 7:2
Total 1:1 7:4

I hope that example helps, thanks!


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
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 10:02 PM
Add condition to formula Pat Excel Worksheet Functions 0 November 16th 04 01:23 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 03:19 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"