Forum Discussion
Calculating months, days, hours, minutes, seconds in Excel
Jo_666 To begin with, I would suggest you forget about the number of months in your calculation.
"One month" becomes rater vague as it may be 28, 29 30 or 31 days long depending on the month and year. If you then want to come-up with some overall average of your 20000 sets of date/time-stamps, you could say "it's 40 days and 10 hrs" and translate that to "roughly one month plus 10 and a half days".
Have attached an example for your reference.
Ok-Feature-4243 My earlier file had nothing to do with NETWORKDAYS.INTL. Not really sure what you are after. Better to start a new conversation and include an example file of what you are dealing with and what results you need.
I get rid of 2021 holidays =NETWORKDAYS.INTL(A2,E2,1,{"2020/9/7","2020/10/12","2020/11/11","2020/12/25","2020/12/28"}) and the result between
| 2020-08-10 9:46 |
and
| 2020-08-11 9:46 |
= 2
When I get rid of the holidays, result remain the same.
I don't think this is correct. Much appreciated if you could provide answer.