Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > Internet Gambling > Software

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2005, 12:34 PM
Guest
 
Posts: n/a
Default Spreadsheet Question - how to total a Time column

I've got a column of hours and minutes (00:00) I'm trying to total. Each cell is the result of a start and end time that works fine.

What I can't get is a result once the total exceeds 24 hrs. I've tried -
<ul type="square"> =SUM(C.1:C50)[/list]and get "#####" as a result.

I checked the first few cells (less than 24 hrs total) and it works.

Any suggestions? Thanks.

[img]/images/graemlins/confused.gif[/img]
Reply With Quote
  #2  
Old 12-15-2005, 12:56 PM
SamIAm SamIAm is offline
Junior Member
 
Join Date: Apr 2004
Location: Under the gun.
Posts: 3
Default Re: Spreadsheet Question - how to total a Time column

It's not that your column is too narrow, is it?
-Sam
Reply With Quote
  #3  
Old 12-15-2005, 02:29 PM
CrashPat CrashPat is offline
Senior Member
 
Join Date: Jan 2005
Posts: 123
Default Re: Spreadsheet Question - how to total a Time column

Try changing the format of the cells. I use openoffice, not excel so it might be different but if I change from the default formatting to [HH]:MM:SS it works. The brackets around the HH allow it to go past 24 hours, if I leave those off it cycles on the 24 hour clock, so 23:45 + 1:15 results in 01:00 instead of 25:00. You also need to make sure that the column is wide enough to display the result or it will be ###.
Reply With Quote
  #4  
Old 12-15-2005, 02:37 PM
Timer Timer is offline
Senior Member
 
Join Date: Dec 2002
Posts: 128
Default Re: Spreadsheet Question - how to total a Time column

[ QUOTE ]
I've got a column of hours and minutes (00:00) I'm trying to total. Each cell is the result of a start and end time that works fine.

What I can't get is a result once the total exceeds 24 hrs. I've tried -
<ul type="square"> =SUM(C.1:C50)[/list]and get "#####" as a result.

I checked the first few cells (less than 24 hrs total) and it works.

Any suggestions? Thanks.

[img]/images/graemlins/confused.gif[/img]

[/ QUOTE ]

Make sure the format is :

right click the cell&gt;format cells&gt;time&gt; then select (on office 2000 sixth one down or 37:30:55

Try this first, if that doesn't work, I'll try something else.
Reply With Quote
  #5  
Old 12-15-2005, 03:21 PM
SamIAm SamIAm is offline
Junior Member
 
Join Date: Apr 2004
Location: Under the gun.
Posts: 3
Default Re: Spreadsheet Question - how to total a Time column

[ QUOTE ]
Try this first, if that doesn't work, I'll try something else.

[/ QUOTE ]I'm going to add this to the bottom of all my posts.
-Sam
Reply With Quote
  #6  
Old 12-15-2005, 03:30 PM
Guest
 
Posts: n/a
Default Re: Spreadsheet Question - how to total a Time column

[ QUOTE ]
It's not that your column is too narrow, is it?
-Sam

[/ QUOTE ]

That was my immediate first thought, but no, column width didn't correct it.
Reply With Quote
  #7  
Old 12-15-2005, 03:31 PM
Guest
 
Posts: n/a
Default Re: Spreadsheet Question - how to total a Time column

Thank you. This might be the answer. I'll try it and let you know. Again, muchos gracias. And I'm using OpenOffice 2.0
Reply With Quote
  #8  
Old 12-15-2005, 03:33 PM
Guest
 
Posts: n/a
Default Re: Spreadsheet Question - how to total a Time column

Big thanks to you, too. That's another possibility.
Reply With Quote
  #9  
Old 12-15-2005, 06:07 PM
Guest
 
Posts: n/a
Default Re: Spreadsheet Question - how to total a Time column

[ QUOTE ]
Try changing the format of the cells.

[/ QUOTE ]


ka-ching! problem go bye-bye.

[img]/images/graemlins/smile.gif[/img]
Reply With Quote
  #10  
Old 12-15-2005, 09:26 PM
Timer Timer is offline
Senior Member
 
Join Date: Dec 2002
Posts: 128
Default Re: Spreadsheet Question - how to total a Time column

If you have further problems with Excel, including complicated formula questions you can go to this newsgroup and get good answers quickly:

microsoft.public.excel.misc
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.