Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time differences in excel
I need to work out the difference in minutes between 2 times usually spread over 2 to 3 days, but I also need to exclude any of those minutes that come between 06:00 and 23:00 each day over that period. For Example: Start Date 3/1/2006 07:36 End Date 6/1/2006 19:00 Times to exclude 3/1/2006 06:00-23:00, 4/1/2006 06:00-23:00, 5/1/2006 06:00-23:00, 6/1/2006 06:00-23:00. Can anyone help? -- Nebuchanezer ------------------------------------------------------------------------ Nebuchanezer's Profile: http://www.excelforum.com/member.php...o&userid=30186 View this thread: http://www.excelforum.com/showthread...hreadid=498663 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I import data (distance and time) from MapPoint to Excel? | Excel Discussion (Misc queries) | |||
Keyboard shortcuts for time in Pocket Excel | Excel Worksheet Functions | |||
Excel Date Time to Unix Time | Excel Discussion (Misc queries) | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |