I spent two weeks googling for this and you got me to the formula I needed in 2 minutes. GREAT VIDEO!!
@subhashreenayak8986
Жыл бұрын
So grateful to you sir for this video. It really saved a lot of time.
@evanwindom3265
2 жыл бұрын
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?)
@amorshed
2 жыл бұрын
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.
@venkatraj5491
Жыл бұрын
really... thanks for your valuable support...🙏🙏🙏
@CaknaEmas
4 жыл бұрын
lov it.. short simple and smart
@asadhussain8551
6 жыл бұрын
Easy to Understanding.. Thank You
@DrGrande
6 жыл бұрын
You're welcome!
@aaftabkhan9789
6 жыл бұрын
Thank you very much. Extremely useful video.
@DrGrande
6 жыл бұрын
You are quite welcome - thanks for watching -
@takurtime
6 жыл бұрын
Wonderful tutorial, thanks for sharing!!
@DrGrande
6 жыл бұрын
You're welcome - thank you for watching -
@thisisbige7970
8 жыл бұрын
This is amazing! Do you have a website with these sheets?
@accordeonist
4 жыл бұрын
This video helped me.
@xbertox2099
8 жыл бұрын
Thank you that helped a lot! Clean, easy, simple!
@zzzzzzzzzzzzzzzz9
4 жыл бұрын
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?
@lectureryaseen9984
5 жыл бұрын
many thanks Sir
@nelsoni5390
6 жыл бұрын
Todd Grande, Thank you very much... very helpful!
@DrGrande
6 жыл бұрын
You're welcome!
@randydenote8394
2 жыл бұрын
How do calculate time between pretest that equals 50 (from your data)
@yonatankemelman3226
8 жыл бұрын
Great explanation, helped me . Thank you Todd :J
@munalimbu69
6 жыл бұрын
This is very helpful
@ebertof77
8 жыл бұрын
Very helpful, thank you!!
@DrGrande
7 жыл бұрын
You're welcome.
@Irkeyser
8 жыл бұрын
How do you calculate time difference between two dates and then convert the date to pretest #/cycle?
@farzanzavar3546
3 жыл бұрын
thank you
@punitpatel8275
8 жыл бұрын
How to substract time between (27 Years, 2 Months, 3 Days) -- (6 Years, 4 Months, 30 Days). Thanks...
@martricaallumns5807
8 жыл бұрын
how do you find the first oldest date and time in column D or F?
@rameshmenon1069
3 жыл бұрын
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..
@priyammittal2957
3 жыл бұрын
Same issue with me.... Please help me with the solution if u have got it.
@jayj1268
5 жыл бұрын
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.
@MrMithun20
6 жыл бұрын
How to find difference of ISO format dates i.e,yyyy-Week#-day
@suzannedeb181
8 жыл бұрын
...i need ghe 24 hour mmode no pm/am...need it fast pls.
@jayeshwankawala6313
Жыл бұрын
From Pm to AM Time Calculation Mention,Sir.
@suzannedeb181
8 жыл бұрын
....example: 15:25:15 minus 12:35:40 =
@leftofpunk
8 жыл бұрын
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.
@nelsoni5390
6 жыл бұрын
I also need this formula, Tony did you get a reply or figure it out?
Пікірлер: 40