Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by D4WNO

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

Hi

Could you post some example data with details of what the working hours are and your expected results?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Working hours	Fredrik	Excel Discussion (Misc queries)	1	April 6th 10 08:13 PM
Converting work hours to day/hours/minutes	WxmanPrice	Excel Discussion (Misc queries)	3	October 20th 09 03:08 PM
Calculate hours of work substracting non-working time	[email protected]	Excel Worksheet Functions	2	June 3rd 09 08:53 PM
Determining work hours between dates / hours	Andrew	Excel Worksheet Functions	3	July 30th 08 06:38 PM
Apply a macro to all sheets - save me from hours and hours of work	Excel'ed Failures	Excel Programming	3	January 30th 06 05:48 PM

All times are GMT +1. The time now is 09:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us