#1
|
|||
|
|||
Adding of times total to be in hours
Hi thought this would be simple but .....
MY wife is paid by hour so I created a simple spread sheet: Start time end time and hours worked using a really sophisticated =E5-C5 Ok that works Then have a row for each day of the month ON thebottom row I used =SUM(G2:G32) to get the total number of hours she worked and it works perfectly until the total reaches 22 hours the total them seems to go into days hours minutes etc I'd like the total to be in hours and minutes Is there a way to do this? thanks Ian |
#2
|
|||
|
|||
Hi Ian
You have to use a "user defined" format for the cell: [hh]:mm |
#3
|
|||
|
|||
User defined
Hi
thanks for the reply I've had a look how to I select a user defined format? thanks Ian |
#4
|
|||
|
|||
First selct the cell you want assign a format.
Then from the Menue choose - Home - Click on the small arrow besides "Number" - In the new dialog choose "Number" again, and select the last Item in the list reading "Custom" It will show you the format which is applied to the selected cell. - Where it reads "Type" below you can enter the format you desire e.g. [hh]:mm. The field above gives you a preview how your format affects the cell value. Edit: I have to correct this one: That's nonsense, sorry, formats doesn't affect the value of a cell, only the way it is displayed. The value remains the same! More about customized formats you will find for example on this page: http://office.microsoft.com/en-us/ex...010342372.aspx |
#5
|
|||
|
|||
Thanks that fixed it
cheers Ian |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How obtain accurate total of hours estimated of all subtasks that are a certain type? | pcumming | Project | 3 | 05-14-2014 05:45 PM |
Total Resources | 602chrislys | Project | 1 | 10-04-2010 09:04 AM |
Excel Total page | TryingToHaveFun | Excel | 1 | 09-19-2010 01:49 AM |
Adding a Total row to pivot Table | hannu | Excel | 1 | 09-18-2010 01:15 AM |
Issues with Total # of Pages | zehra216 | Word | 2 | 07-06-2009 08:41 AM |