| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
certain time
I have to compute an extra night pay rate for those who work between 22:00
to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? And is the a formula that will look between these hours only |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
certain time
What result are you looking for? The number of hours worked during that
shift? Or, just some kind of confirmation that they worked at some time during that shift? -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... I have to compute an extra night pay rate for those who work between 22:00 to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? And is the a formula that will look between these hours only |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
certain time
Looking for total hours worked between 2200 to 00600.
"T. Valko" wrote: What result are you looking for? The number of hours worked during that shift? Or, just some kind of confirmation that they worked at some time during that shift? -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... I have to compute an extra night pay rate for those who work between 22:00 to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? And is the a formula that will look between these hours only |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
certain time
Try this:
A2 = start time B2 = end time =(MOD(B2-A2,1)-(A2B2)*MEDIAN(0,B2-6/24,16/24)-MAX(0,MIN(11/12,B2+(A2B2))-MAX(6/24,A2)))*24 -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... Looking for total hours worked between 2200 to 00600. "T. Valko" wrote: What result are you looking for? The number of hours worked during that shift? Or, just some kind of confirmation that they worked at some time during that shift? -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... I have to compute an extra night pay rate for those who work between 22:00 to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? And is the a formula that will look between these hours only |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
![Karl Davidson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
