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.
I spent two weeks googling for this and you got me to the formula I needed in 2 minutes. GREAT VIDEO!!
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?)
So grateful to you sir for this video. It really saved a lot of time.
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?
This video helped me.
lov it.. short simple and smart
Thank you very much. Extremely useful video.
You are quite welcome - thanks for watching -
Great explanation, helped me .
Thank you Todd
:J
Wonderful tutorial, thanks for sharing!!
You're welcome - thank you for watching -
Easy to Understanding.. Thank You
You're welcome!
thank you
many thanks Sir
Thank you that helped a lot! Clean, easy, simple!
This is very helpful
Very helpful, thank you!!
You're welcome.
Todd Grande, Thank you very much... very helpful!
You're welcome!
How do you calculate time difference between two dates and then convert the date to pretest #/cycle?
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 find the first oldest date and time in column D or F?
How do calculate time between pretest that equals 50 (from your data)
...i need ghe 24 hour mmode no pm/am...need it fast pls.
How to substract time between (27 Years, 2 Months, 3 Days) -- (6 Years, 4 Months, 30 Days). Thanks...
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 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.
....example: 15:25:15 minus 12:35:40 =
How to find difference of ISO format dates i.e,yyyy-Week#-day
From Pm to AM Time Calculation Mention,Sir.
Send practice file link bro
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?