How to work out working hours?

D

D4WNO

When I am working out the difference between 2 dates for working dates
use a calculation similar to:

=NETWORKDAYS(A1,B1)

But how can I do the same for working hours? To put this into context
am working with problem tickets and wish to see how many are resolve
within 8 working hours, 24 working hours etc.

I hope you can help, thank you in advance :
 
S

Spencer101

D4WNO;1605722 said:
When I am working out the difference between 2 dates for working dates
use a calculation similar to:

=NETWORKDAYS(A1,B1)

But how can I do the same for working hours? To put this into context
am working with problem tickets and wish to see how many are resolve
within 8 working hours, 24 working hours etc.

I hope you can help, thank you in advance :)
Click to expand...

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My calendar keeps returning to working hours of 08:00h to 17:00h even after I set it to 24h? 1
How to calculate difference between two date & time along with working hours and days 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
work hours with different hour prices 12
need help with Formula 1
problem with time subtraction 7
Inconsistent formatting of section numbers 0
How to implement two shifts per day with multiple teams 0

Top