Excel needs hh:mm where hh>24 for hours worked per week
 

In order to calculate time worked per week in a time sheet, excel needs to
provide support for hh:mm formats where the hh argument is greater than 24,
for example if I worked 40 hours and 15 minutes in a week, I should be able
to add (8:00+7:30+8:30+8:00+8:15)=40:15. I should be able to calculate
40:00-(time worked so far) to get how much time I still need to work this
week.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

If I'm understanding you correctly, this can be done. Please see the
following post:

http://www.pdbook.com/index.php/exce...g_total_hours/

--
Regards,
John Mansfield
http://www.pdbook.com


"pmba" wrote:

In order to calculate time worked per week in a time sheet, excel needs to
provide support for hh:mm formats where the hh argument is greater than 24,
for example if I worked 40 hours and 15 minutes in a week, I should be able
to add (8:00+7:30+8:30+8:00+8:15)=40:15. I should be able to calculate
40:00-(time worked so far) to get how much time I still need to work this
week.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

On Mon, 16 May 2005 05:44:22 -0700, "pmba"
wrote:

In order to calculate time worked per week in a time sheet, excel needs to
provide support for hh:mm formats where the hh argument is greater than 24,
for example if I worked 40 hours and 15 minutes in a week, I should be able
to add (8:00+7:30+8:30+8:00+8:15)=40:15. I should be able to calculate
40:00-(time worked so far) to get how much time I still need to work this
week.




Merely format your result cell as [h]:mm

The brackets around the h prevent the hours from "rolling over" every 24.


--ron