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.
Thanks so much for your help. You're right, dropping months is the way to go and made things much easier. I've got it sorted now. Really appreciate the help!
Jo_666 Glad I could help!
Any chance you can also tell me how to also include ways to exclude weekend and holidays?
Ok-Feature-4243 You need to look into the NETWORKDAYS.INTL function. It allows for excluding both weekends and holidays.
My understanding, workday.intl function is to find the date, after a certain days from the starting date.
That said, I should already know the number of days, I just don't know when the ending date and workday.intl can tell me when the ending date in this scenario. Is my understanding correct?
In my case, I have start date and ending date, what I do not know is the number of days and hours and the average days/hours between the two dates.
Any chance you can show me by using the same file that you attached on your previous message on this thread on how workday.intl can works in calculating days and hours and the average between starting and end date?
