| 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 |
| 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) | |||
Threaded Mode
