| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing non Work Hours from Excel calculation
I am trying to work out the minutes elapsed for a call monitoring
system. The hours monitored are between 05:30 and 19:00 - so if a call gets logged outside of these hours then the minutes calculated will be calculated from 05:30 the same day if logged on or after midnight or 05:30 the next day if logged before midnight (ie the next 05:30). Any ideas ? - Thanks |
| 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
