| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Project planning with Excel
Greetings everyone, I am constructing an excel sheet to keep track on the hours my teams are spending on certain projects. I would like to sum all the hour reports into one cell which should be no problem. However I have some difficulties with the cell formats [h]:mm which does not convert the value in the the output I would expect. Example: 09:00 - 19:00 = 10:00 (timeformat) 09:00 - 19:00 = 10:00 09:00 - 19:00 = 10:00 Total should be 30:00 but that wont work neither with timeformat or [h]:mm. Does anyone have a tip for this ?? Thanks alot in advance :D -- MPark ------------------------------------------------------------------------ MPark's Profile: http://www.excelforum.com/member.php...o&userid=28184 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#2
|
|||
|
|||
|
Project planning with Excel
you seem on the right track.
What doesn't work? "MPark" wrote: Greetings everyone, I am constructing an excel sheet to keep track on the hours my teams are spending on certain projects. I would like to sum all the hour reports into one cell which should be no problem. However I have some difficulties with the cell formats [h]:mm which does not convert the value in the the output I would expect. Example: 09:00 - 19:00 = 10:00 (timeformat) 09:00 - 19:00 = 10:00 09:00 - 19:00 = 10:00 Total should be 30:00 but that wont work neither with timeformat or [h]:mm. Does anyone have a tip for this ?? Thanks alot in advance :D -- MPark ------------------------------------------------------------------------ MPark's Profile: http://www.excelforum.com/member.php...o&userid=28184 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#3
|
|||
|
|||
|
Project planning with Excel
This is how I see your problem can be solved! +-------------------------------------------------------------------+ |Filename: time workaround.zip | |Download: http://www.excelforum.com/attachment.php?postid=3915 | +-------------------------------------------------------------------+ -- Ctrl-T ------------------------------------------------------------------------ Ctrl-T's Profile: http://www.excelforum.com/member.php...o&userid=28192 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#4
|
|||
|
|||
|
Project planning with Excel
Thanks alot man. You saved my day :D -- MPark ------------------------------------------------------------------------ MPark's Profile: http://www.excelforum.com/member.php...o&userid=28184 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#5
|
|||
|
|||
|
Project planning with Excel
ONE LITTLE PROBLEM PROBLEM:[/b] THE DEFAULT TIME FORMAT DOES NOT ALLOW A TIME VALUE TO EXCEED 24 HOURS. FOR EXAMPLE, BY ENTERING A TIME OF 28:56:00, THE RESULT IS 04:56:00. [b]SOLUTION: Change the format of the cell by placing brackets around the hour, [HH]:MM:SS. The result is displayed as 28:56:00. -- Ctrl-T ------------------------------------------------------------------------ Ctrl-T's Profile: http://www.excelforum.com/member.php...o&userid=28192 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#6
|
|||
|
|||
|
Project planning with Excel
last update +-------------------------------------------------------------------+ |Filename: time workaround 1.zip | |Download: http://www.excelforum.com/attachment.php?postid=3916 | +-------------------------------------------------------------------+ -- Ctrl-T ------------------------------------------------------------------------ Ctrl-T's Profile: http://www.excelforum.com/member.php...o&userid=28192 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#7
|
|||
|
|||
|
Project planning with Excel
It also has to be able to work under these conditions which it wont... 21:00 - 03:00 = 06:00 10:00 - 17:00 = 07:00 Total usage = 13:00 -- MPark ------------------------------------------------------------------------ MPark's Profile: http://www.excelforum.com/member.php...o&userid=28184 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#8
|
|||
|
|||
|
Project planning with Excel
Here it is!!!  I added dates to the cell-format. +-------------------------------------------------------------------+ |Filename: time workaround 1.zip | |Download: http://www.excelforum.com/attachment.php?postid=3917 | +-------------------------------------------------------------------+ -- Ctrl-T ------------------------------------------------------------------------ Ctrl-T's Profile: http://www.excelforum.com/member.php...o&userid=28192 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
|
#9
|
|||
|
|||
|
Project planning with Excel
But it doesnt really work the way I need it to work. I guess I really need someone to look at the specific set up in order to be able to see exactly what I mean. But thanks alot for the great work you did and posted. -- MPark ------------------------------------------------------------------------ MPark's Profile: http://www.excelforum.com/member.php...o&userid=28184 View this thread: http://www.excelforum.com/showthread...hreadid=477161 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| How can I move Project tasks into an Excel outline? | Excel Discussion (Misc queries) | |||
| How do I manage a residential construction project with Excel? | New Users to Excel | |||
| How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
