Thanks bro, I saw few videos but it has not turn as I expected, but the shown formula yours is perfectly matched. I would like to thanks for giving knowledge.
@ca.josephjoyputhussery Жыл бұрын
Thanks a lot. You are life saver...
@nabihayousuf33447 ай бұрын
VERY HELPFUL! THANKS
@annalynbutoy42074 ай бұрын
Thanks I found this video..
@sylkiuniky68065 ай бұрын
Thank you so much!
@CaliKyle032 жыл бұрын
Brilliant, thanks so much.
@asif82584 ай бұрын
Thanks a lot
@shaikhruhul70952 жыл бұрын
Help alot thanks 🙏
@NaZiaCookZ Жыл бұрын
Useful video, could you please help how to find days, hours from two timestamps
@user-mm7gs2ym8j5 ай бұрын
=text(K9,"mm/dd/yyyy")&" "&text(L9,"hh:mm:ss") Just replace the K9 and L9 with your cell IDs
@korolova21Ай бұрын
Thanks!
@AJITHKUMAR-wu7teАй бұрын
While applaying formula How you are selecting that date and time cells
@karenkehoe39385 ай бұрын
thaaaaaaaaaaaaaaaank you! I tried so many ways that didnt work
@selvarasu23132 жыл бұрын
Please help us some text and time on single cell how to enter the formula
@user-ns7fw8ub6m8 ай бұрын
How to add AM and PM ?
@javierrodas9816 Жыл бұрын
How to separate date and time
@Jhonnyzilla Жыл бұрын
way better method: =A2 + B2. Then use "long date format" or manual format "dd.mm.yyyy hh:mm" or similar for the column. Excel is able to add up dates and times.
@junaidiqbal7086 Жыл бұрын
thanks
@dominperca Жыл бұрын
Yes, that works faster. Thanks!
@juniorg61357 ай бұрын
Yes, Confirmed this was faster. Itll show no time, but go to format cell, then select the time you would like to show. Nates way worked, but couldn't format change the time to show AM or PM, it only showed 24 hour format
@cliktoview87504 ай бұрын
and also how to add text in the last if we have to add