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

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

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

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

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

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

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

Project planning with Excel
 

Here it is!!! :cool:
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

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