Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |