Thanks a lot. So simple but nowhere else on net this was explained. Everywhere else it was only unnecessary detail that would only bring more confusion.

@palobar9974

2 жыл бұрын

Totally agree

Thank you for this! I was circling around for an hour now and glad that I found this!

thank you this was perfect - was missing the Square brakcet!

This was really perfect, i was searching for this since long

I’ve been looking for this for a few weeks now. Thank you!

thank you so much -none of the literature talks about the square brackets!! Been going in circles until i found your video!

I can't thank you enough! this was very helpful

Great video, straight to the point, this helped me a lot!

Thank you man, that really worked

Thanks. This is really useful

Very Helpful... Loved it...

I spent an HOUR trying to figure this out using Excel's "help". After watching your video it took me 10 minutes to get it right. Thank you Sir. BTW, what accent is that :)?

Fantastic. Thank you

Short and sweet... Thanks...

Really Great, thank you

thank you. you save my life

Thank you.

Thank you it worked and nice trick

Thank you so much for sharing

So helpful VT. I was struggling to find formula . Supper

Thanks for sharing this

Thank you so much for this video, it's exactly what I needed :) =

How to set the start and end format as dd/mm/yy as shown in the video

Thanks for your help...😀

Thank you!

May God bless you.

If , i use different column like start date, start time, end date ,end time... What is the formula??

Thanks alot.❤❤❤❤

what if i want to calculate the date with this format 20230801 04:30 like this only will it work?

Good trick with square bracket

thanks

how can I calculate difference of hours for only weekdays

how to calculate date month year hour minute on 18days . start , end , difference

thanku

Thanks

excluding saturday sunday???

Hello In My Excel, I have two columns I have shared the data of my columns. Column1: 2023-07-24T06:44:03.000Z Column2: 2023-07-24T06:44:16.000Z How do I get these two columns different in "Seconds" Only?

8 ай бұрын

use: "=SECOND(B1 - A1)" without the quotes, should work, give it a shot

grandissimo

Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.

Hi, you are awesome - thank you!!!

Thank you!