Great video. Something to keep in mind though: In the first method using the YEAR() function to find out the difference in years will still produce 2 years even if the starting date is in April 2013. We might think (in general) that the time difference between April 2013 and March 2015 is 1 year 11 months, which would be the output is DATEDIF() is used like in the final row.
I WAS NOT ABLE TO GET THE RIGHT ANSWER.. WHENVER I PRESS ENTER I GET VALUE# WOULD LIKE TO KNOW IF THE ORIGINAL DATE AND TIME IN THE SAME CELL HAS TO BE IN ANY PARTICUALAR FORMAT LIKE ... GENERAL . OR NUMBER..
Is there a way to have it give me the number of days, hours and then minutes? I see that you can display the information in total days total hours etc by reflecting the difference if multiple ways, but I need it to show the number of days in exact 24 hour increment and then the remaining time that's less than 24 hours to display the total hours in 60 minute chunks and then anything less than an hour in minutes.
So grateful to you sir for this video. It really saved a lot of time.
Nice! The custom formatting was the piece I was missing. Thanks! (Ain't it great when a 7 year old video is still solving problems for folks?)
Great video. Something to keep in mind though: In the first method using the YEAR() function to find out the difference in years will still produce 2 years even if the starting date is in April 2013. We might think (in general) that the time difference between April 2013 and March 2015 is 1 year 11 months, which would be the output is DATEDIF() is used like in the final row.
really... thanks for your valuable support...🙏🙏🙏
This is amazing! Do you have a website with these sheets?
lov it.. short simple and smart
Thank you very much. Extremely useful video.
You are quite welcome - thanks for watching -
Easy to Understanding.. Thank You
You're welcome!
This video helped me.
Wonderful tutorial, thanks for sharing!!
You're welcome - thank you for watching -
Great explanation, helped me .
Thank you Todd
:J
Thank you that helped a lot! Clean, easy, simple!
Todd Grande, Thank you very much... very helpful!
You're welcome!
many thanks Sir
Very helpful, thank you!!
You're welcome.
This is very helpful
thank you
Thank you.
How do you get the days when the beginning date is valued, but has no end date. For example, an employee spreadsheet.
Thank you again.
I want minutes with a catch.
Lets say, the clock starts at 9am and stops 5pm. Plus if you have a public holiday with no work been done?
How do you calculate time difference between two dates and then convert the date to pretest #/cycle?
how do you find the first oldest date and time in column D or F?
How do calculate time between pretest that equals 50 (from your data)
How to substract time between (27 Years, 2 Months, 3 Days) -- (6 Years, 4 Months, 30 Days). Thanks...
I WAS NOT ABLE TO GET THE RIGHT ANSWER.. WHENVER I PRESS ENTER I GET VALUE# WOULD LIKE TO KNOW IF THE ORIGINAL DATE AND TIME IN THE SAME CELL HAS TO BE IN ANY PARTICUALAR FORMAT LIKE ... GENERAL . OR NUMBER..
Same issue with me....
Please help me with the solution if u have got it.
How to find difference of ISO format dates i.e,yyyy-Week#-day
Is there a way to have it give me the number of days, hours and then minutes? I see that you can display the information in total days total hours etc by reflecting the difference if multiple ways, but I need it to show the number of days in exact 24 hour increment and then the remaining time that's less than 24 hours to display the total hours in 60 minute chunks and then anything less than an hour in minutes.
I also need this formula, Tony did you get a reply or figure it out?
...i need ghe 24 hour mmode no pm/am...need it fast pls.
From Pm to AM Time Calculation Mention,Sir.
....example: 15:25:15 minus 12:35:40 =
Send practice file link bro