Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting different workinghour types
I have a problem
Itry to calculate with excel how much night hours evening hours i have done example Working hours are starting time in c7 15:30 and end time D7 23:59 and if i get extra pay between 18:00 and 21:00 how can i calculate these hours in evening bonuses |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting different workinghour types
Total hours worked (formula in E7) =D7-C7 Hours outside evening
time (formula in F7) =(TIME(18,0,0)-C7)+(D7-TIME(21,0,0)) Hours during evening time (formula in G7) =E7-F7 With 15:30 and 23:59, we get 8:29 5:29 3:00 Or one formula =(D7-C7)-((TIME(18,0,0)-C7)+(D7-TIME(21,0,0))) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Wanderer" wrote in message ... I have a problem Itry to calculate with excel how much night hours evening hours i have done example Working hours are starting time in c7 15:30 and end time D7 23:59 and if i get extra pay between 18:00 and 21:00 how can i calculate these hours in evening bonuses |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting different workinghour types
Thank you for your solution, but when I tryed it in hours C7 0:00 D7 19:30
it gave me answer 3:00 and it should be 1:30 there is somthing i missed when i tryed to alter the formula so it would calculate above mentioned problem. "Bernard Liengme" wrote: Total hours worked (formula in E7) =D7-C7 Hours outside evening time (formula in F7) =(TIME(18,0,0)-C7)+(D7-TIME(21,0,0)) Hours during evening time (formula in G7) =E7-F7 With 15:30 and 23:59, we get 8:29 5:29 3:00 Or one formula =(D7-C7)-((TIME(18,0,0)-C7)+(D7-TIME(21,0,0))) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Wanderer" wrote in message ... I have a problem Itry to calculate with excel how much night hours evening hours i have done example Working hours are starting time in c7 15:30 and end time D7 23:59 and if i get extra pay between 18:00 and 21:00 how can i calculate these hours in evening bonuses |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Counting the number of Error Types | Excel Worksheet Functions | |||
Encryption Types | Excel Discussion (Misc queries) | |||
For all you finance types... | Excel Discussion (Misc queries) | |||
new chart types | Charts and Charting in Excel |