| Home |
| Search |
| Today's Posts |
|
#20
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing non Work Hours from Excel calculation
the start dates and end dates based on the call so they are not static.
by changing the date from (5,30,0) to (6,30,0) does not output the correct information ! still getting negative values (###) A B C 13/02/2006 07:55 13/02/2006 07:59 ### 10/02/2006 18:55 13/02/2006 06:35 0:10 13/02/2006 22:10 14/02/2006 07:00 0:30 14/02/2006 07:55 14/02/2006 08:00 ### 13/02/2006 07:55 14/02/2006 08:00 12:35 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Calculation of full hours | Excel Worksheet Functions | |||
| how to add hours and minutes in excel | New Users to Excel | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| Need a function that separates over-lapping work shift hours. | Excel Worksheet Functions | |||
Threaded Mode
