calc. time between 2 dates INCLUDING weekends!

hina04

New Member
Joined
Oct 22, 2017
Messages
1
Hi!

I need to calculate the time [h]:mm:ss between 2 different dates. working hours are monday-sunday & times are 05:00:00 - 18:00:00

Public Holidays should be excluded!

Example:

A complaint was lodged on 26/09/2017 09:00:00
Solved 29/09/2017 15:00:00

28/09/2017 is a PUBLIC HOLIDAY

I can do this calculation using networkdays to exclude weekends, but not sure how to include a 7 day week + public holidays.

Please help!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,771
Hi
Welcome to the board

You did not post which version of excel you have.

For excel 2010+ you can use instead the NETWORKDAYS.INTL() function that lets you define your weekend days (in this case none).
 

Watch MrExcel Video

Forum statistics

Threads
1,095,369
Messages
5,444,059
Members
405,264
Latest member
JohnP1972

This Week's Hot Topics

Top