PC Review


Reply
Thread Tools Rate Thread

Calculating hours

 
 
Thomas
Guest
Posts: n/a
 
      5th Mar 2009
I am trying to register my working hours, but when I try to add up a column
of hours it only adds up correctly if the total is less than 24 hours.

How do I correct this?
--
Thomas Jørgensen
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      5th Mar 2009
Are you really adding times...

Maybe it's adding correctly, but not displaying what you want.

Try changing the number format for that cell to:
[hh]:mm:ss



Thomas wrote:
>
> I am trying to register my working hours, but when I try to add up a column
> of hours it only adds up correctly if the total is less than 24 hours.
>
> How do I correct this?
> --
> Thomas Jørgensen


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating hours elapsed when date/ time > 24 hours Mike Microsoft Excel Discussion 1 9th Apr 2009 03:22 PM
Calculating 30 hours in a day. =?Utf-8?B?SmFnMTA4?= Microsoft Excel Programming 1 25th Nov 2005 09:59 AM
Calculating elapsed time in hours:minutes (minus weekends [48 hours]) bigjess007 Microsoft Excel Worksheet Functions 2 20th Jul 2004 08:28 AM
Calculating hours between a shift time to include core hours only Darren Elsom Microsoft Excel Programming 3 21st Mar 2004 09:41 PM
Calculating hours between a shift time to include core hours only Darren Elsom Microsoft Excel Worksheet Functions 2 20th Mar 2004 06:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:51 AM.