I am glad that it is useful!! Thanks for your continued support!
@wjperdue
11 жыл бұрын
These videos are so helpful. Almost every question I have I can find answers to. Thanks a million for your assistance.
@excelisfun
11 жыл бұрын
You are welcome!
@WallsBecomeDoors
11 жыл бұрын
Hello, Love your tutorials. They are helping me greatly in my Excel self-education. It seems to me that this formula would cease to be accurate if the time of day was EARLIER in the later date. What I did was extract the elements of each date's time using two Time() functions, subtract the earlier date's time from the later date's time, and then add them to the Networkdays total (which might also end up subtracting, depending). Anyway, thanks again for all the help!
@thangavelz
10 жыл бұрын
Awesome,.. Thanks for the video. the way you explained was really good and simple,
@tirathmistry
14 жыл бұрын
Awesome video tutorial I lean a lot's of new excel trick form your awesome video tutorial Your presentation skill is amazing Keep up good work man God bless you :-)
@excelisfun
14 жыл бұрын
Try these video titles: Igor's Physics Class Linear Regression Tricks Video For Carly: Chemestry 2 X Y Scatter Diagrams 1 Chart Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression
@achyutsingh
5 жыл бұрын
great 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
@excelisfun
12 жыл бұрын
@dodjavola , post question to: mrexcel [dot] com/forum
@fireblade2806
9 жыл бұрын
First off, I've learnt alot from your videos...however, I have my doubts about the method above, because the networkingdays function calculates the start and end day as a full day, when in fact they are only fractional days, because of the time on each day. Am I making a mistake, or is this method indeed faulty, and if so, is there a correct method known?
@hennessy195
5 жыл бұрын
when formatting a time sheet or invoice and the pay rate is different from Monday to Friday normal rate, for example for Saturday (time and a Half), Sunday (Double Time), and Holidays (Double Time), but you still want to calculate 1-40 hours as Normal rate, 41-50 hours as Time and a Half and 51 hours and above as Double time. can you make a video on how would I formulate that on Excel?
@ShriN23
11 жыл бұрын
Hi i need some help, This video is of great help first of all. However can you please help with below query: I need hours:min between two days excluding weekends as i have to substract this value with another value. For Example: difference between 8/27/2013 10: AM and 8/27/2013 12:00 PM should return 2:00 hours similarly between 8/26/2013 10: AM and 8/27/2013 12:00 PM should return 26:00 hours
@Red_Boar
3 жыл бұрын
How exclude the non business hours in this
@isranim
5 жыл бұрын
I have set of data wherein I have start end and end date but there many cells therein has no end date given (there are blank as task has not completed) in this case which formula I should use and also I have to exlcude weekend.. Pls suggest.
@Lens_luminous
10 жыл бұрын
Does excel by default takes Saturday as weekend or is it only Sunday...??
@annafvicente
12 жыл бұрын
help - i need to add 60 days to a particular date, but excluding the bank holidays. It would include the weekends though so i cant seem to use the workday function. thanks!
@Qtrainer
4 жыл бұрын
I have task that starts 05/08/20 at 3:00 PM and I need to add 48 hours excluding weekends. Any thoughts?
@AnwarKhan-fm4nv
6 жыл бұрын
I have created leave tracker but if I am entering leave from Tuesday 27th march to next week monday 2nd april it counting weekend also. how to exclude it?
@klimlib
12 жыл бұрын
Please, I need help. I have to compare 2 columns with EXACT function. First column: time is in form like 15:30 Second column is in form like 15:30:00....seconds are 00 in whole column. If I try EXACT function on these 2 cells i get FALSE and it is assumed that both represent same time. AM or PM is not important.
@mora4773
10 жыл бұрын
Hi, was trying to figure out 26- 4 = 23 (if we include counting from 4) - 2 days of hols shud be 21. But why 16? Sorry guys, im just trying to figure out.
@dodjavola
12 жыл бұрын
Hi I have problem that i cant solve with tutorials. i need to calculate years of service, and it goes like thiis: i have years of service before employment in this company, then i have years of service in this company. yos before employment are in format years motnh days, and then must calculate yos in company til "today" and then add those two in separate column years month days. hope u understand what i tried to explain.
@ehsanilyas5136
5 жыл бұрын
If i wanna find only holidays date of full year ,what i should do ?
@33rumieru
9 жыл бұрын
hi,i am having a problem when the months are different.the formula only calculate the date difference but ignoring the month difference.anyone can help?thanks :)
Пікірлер: 23