| 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 :) |
| 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 | |||
Threaded Mode
