How many hours between 2 times including dates

[Jaffabfc]

Good Morning,

In cell A2 i am putting 10/01/19 12:00 in cell G2 i am putting 12/01/19 16:00.

I am wanting to work out the difference between these 2 times.

But the catch is i dont want the hours counting between 16:00 and 08:00 and also weekends/bank holidays if possible.

At the minute i cant even get the hours right can someone help.

thanks

 

[Ramballah]

https://exceljet.net/formula/get-days-hours-and-minutes-between-dates

 

[kensandy1]

If you add =G2-A2 into a cell and change that cell format to [hh]:mm:ss, it will give you the straight time between the two times. To remove the hours between 4p - 8p, weekends, and bank holidays, I don't believe there's a way to do so without VBA.

 

[Jaffabfc]

https://exceljet.net/formula/get-days-hours-and-minutes-between-dates

i saw this after posting this, but i am wanting to workout if there was weekends in between and also bank holidays if possible.

thanks

 

[kensandy1]

What are the bank holidays? Do they fall on the same dates every year?

 

[Jaffabfc]

most do yes, but not all.

I could provide a list no problem

 

[Jaffabfc]

https://exceljet.net/formula/get-days-hours-and-minutes-between-dates

ive copied this and this also doesnt seem to work

 

[Ramballah]

ive copied this and this also doesnt seem to work

dont copy it lol. learn from it. im not giving you the answer XD. im giving you the "textbook" its better to learn something and get your own answer then to copy it and not understand it. (Unless if its some big macro thing) but this is something not too difficult if its not impossible.