Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2014, 06:10 AM
jen0dorf jen0dorf is offline Adding of times total to be in hours Windows 7 64bit Adding of times total to be in hours Office 2007
Novice
Adding of times total to be in hours
 
Join Date: Jun 2014
Posts: 4
jen0dorf is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-19-2014, 08:04 AM
whatsup whatsup is offline Adding of times total to be in hours Windows 7 64bit Adding of times total to be in hours Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi Ian

You have to use a "user defined" format for the cell:
[hh]:mm
Reply With Quote
  #3  
Old 06-19-2014, 08:11 AM
jen0dorf jen0dorf is offline Adding of times total to be in hours Windows 7 64bit Adding of times total to be in hours Office 2007
Novice
Adding of times total to be in hours
 
Join Date: Jun 2014
Posts: 4
jen0dorf is on a distinguished road
Default User defined

Hi

thanks for the reply I've had a look how to I select a user defined format?

thanks

Ian
Reply With Quote
  #4  
Old 06-19-2014, 08:57 AM
whatsup whatsup is offline Adding of times total to be in hours Windows 7 64bit Adding of times total to be in hours Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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
Reply With Quote
  #5  
Old 06-20-2014, 11:53 PM
jen0dorf jen0dorf is offline Adding of times total to be in hours Windows 7 64bit Adding of times total to be in hours Office 2007
Novice
Adding of times total to be in hours
 
Join Date: Jun 2014
Posts: 4
jen0dorf is on a distinguished road
Default

Thanks that fixed it

cheers

Ian
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding of times total to be in hours How obtain accurate total of hours estimated of all subtasks that are a certain type? pcumming Project 3 05-14-2014 05:45 PM
Adding of times total to be in hours Total Resources 602chrislys Project 1 10-04-2010 09:04 AM
Adding of times total to be in hours Excel Total page TryingToHaveFun Excel 1 09-19-2010 01:49 AM
Adding of times total to be in hours 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft