Wednesday, January 30, 2019
Calculate the difference between dates
You have a start date and and end date and want to know how many days are in between team. Or want to know how many works days or months or even years are between these dates. Trying doing this by hand or even with a calculator and you'll go crazy. Try doing this will Excel and you'll be done in less time it takes to get a cup of coffee. Check out the video to see how to do the calculate the difference between dates with various date functions.
Subscribe to:
Post Comments (Atom)
reat Video. I have one thing to ask. I also have to calculate the total hours within the working hours. exp. my start date is 19/4/2019 10:00am and end date is 26/4/2019 7:00 pm and working hours are start 9:00 am and end is 8:00 pm everyday (excluding Sunday). how do I calculate the total time in days hours and minutes. Thanks in advance
ReplyDelete