| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for time
Hi I have been working on some information that shows when a job was logged
and when it was then completed. I have times for these both and have been able to work out the difference between these dates in workdays and figure out the times ( dd:hh:mm) but I now need an if statement for if the time to only count hours after 9am and before 5pm. For example I want to work out 32 working hours from 09/01/2008 06:53 I have worked out the working days so I currently have 10/01/2008 14:53 but I only want it to work out the 32 hours from 09:00 - 17:00 every day Is there any way of doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement to compare time cell to a time | Excel Worksheet Functions | |||
| If statement for time | Excel Discussion (Misc queries) | |||
| if then statement = time | Excel Worksheet Functions | |||
| If statement with time | Excel Discussion (Misc queries) | |||
| IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
Threaded Mode
