| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to work out working hours?
When I am working out the difference between 2 dates for working dates I use a calculation similar to:
=NETWORKDAYS(A1,B1) But how can I do the same for working hours? To put this into context I am working with problem tickets and wish to see how many are resolved within 8 working hours, 24 working hours etc. I hope you can help, thank you in advance :) |
|
#2
|
|||
|
|||
|
Quote:
Could you post some example data with details of what the working hours are and your expected results? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working hours | Excel Discussion (Misc queries) | |||
| Converting work hours to day/hours/minutes | Excel Discussion (Misc queries) | |||
| Calculate hours of work substracting non-working time | Excel Worksheet Functions | |||
| Determining work hours between dates / hours | Excel Worksheet Functions | |||
| Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
Hybrid Mode
