LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default work hours with different hour prices

Hi. I need to calculate the numer of hours (with a 30mim range) between diferent shifts.
For example...
I go to work at 6am and leave at 23h. As my payments are different depending of my shift i need to know how many hours i worked between 7 to 22 and how many i worked from 22 to 7.

Can you help me please? I have been thinking of a way of do this but im not getting it...

Diogo
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ROUND UP HOURS to the next quarter hour SueSea Excel Discussion (Misc queries) 2 February 27th 08 11:35 PM
How do I add hours and minutes without 24 hour limit Cycling Steven Excel Worksheet Functions 1 January 25th 08 02:18 PM
How to count hours- and multiply with my wage per hour... Sofus Excel Discussion (Misc queries) 4 February 4th 07 10:34 PM
How can I add hours and minutes then multiply by cost per hour? Tom DiBell Excel Worksheet Functions 1 May 8th 06 07:52 PM
total work hours for 24 hour on-call schedules Kate Excel Discussion (Misc queries) 1 February 7th 06 03:01 AM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"