I need a help. When I type 14.23 and press enter key in a cell automatically today's date and the time 2;23pm should come for example "06/june/2022 2:23PM"
I shall be grateful to you for providing a solution to my problem mentioned below : I am preparing an excel sheet on dates. I am keying in 4 dates in a row. In the next cell, I want the latest date to be returned for which, I used the formula, =max(cell1, cell2, cell3, cell4). On pressing enter key, the latest of the 4 dates is correctly returned in cell5. However, when the cells 1 to 4 are blank, cell5 returns a value, 00-01-00. (All these 5 cells are marked as 'short date' format). But want the result also to be blank when other 4 cells are blank. Please advise how to overcome this problem.
First of all, if the cells are continuous like A1, A2, A3 and A4, you can use the formula =MAX(A1:A4) instead of =MAX(A1, A2, A3, A4) To avoid the formula returning 00-01-1900 against blank values, you can combine the above formula with IF function. =IF(MAX(A1:A4)=0,"",(MAX(A1:A4)))
@@XLnCADMalayalam Thank you very much, Mr.Ajay Anand. Your lessons are very simple and easy to understand. I have subscribed your channel for continuous learning. Thanks onceagain.
രണ്ടു തിയ്യതികൾ തമ്മിൽ datedif ഫോർമുല ഉപയോഗിച്ച് - years /months/ days കാണുമ്പോള് (Service :- ex: From 03/01/2000 To 31/12/2000 and From 05/06/2001 To 30/06/2001 = 0 years - 11 months - 29 days + 0 years - 0 months - 26 days = Total കാണുമ്പോൾ 0 years - 11 months - 55 days എന്ന് ലഭിക്കും.) ഉത്തരം 1 year - 0 month - 25 days ഇങ്ങനെ ലഭിക്കാൻ എന്ത് ചെയ്യണം?
Hello sir The formula will be like as 12:00 PM 12:30 PM 1:00 PM 02:00 PM 03:00 PM Is'nt it? This is sabuchetten from Saudi Arabia Thank u very much. Regards Sabuchetten ALKHOBAR
I need a help. When I type 14.23 and press enter key in a cell automatically today's date and the time 2;23pm should come for example "06/june/2022 2:23PM"
Very useful. Thank you
😀
Is it possible to insert image in vlookup ?
I shall be grateful to you for providing a solution to my problem mentioned below :
I am preparing an excel sheet on dates. I am keying in 4 dates in a row. In the next cell, I want the latest date to be returned for which, I used the formula, =max(cell1, cell2, cell3, cell4). On pressing enter key, the latest of the 4 dates is correctly returned in cell5. However, when the cells 1 to 4 are blank, cell5 returns a value, 00-01-00. (All these 5 cells are marked as 'short date' format). But want the result also to be blank when other 4 cells are blank. Please advise how to overcome this problem.
First of all, if the cells are continuous like A1, A2, A3 and A4, you can use the formula =MAX(A1:A4) instead of =MAX(A1, A2, A3, A4)
To avoid the formula returning 00-01-1900 against blank values, you can combine the above formula with IF function.
=IF(MAX(A1:A4)=0,"",(MAX(A1:A4)))
@@XLnCADMalayalam Thank you very much, Mr.Ajay Anand. Your lessons are very simple and easy to understand. I have subscribed your channel for continuous learning. Thanks onceagain.
Excellent n very informative👍
Glad it was helpful!😀
Great video. Excellent narration. Thank you 😊 💓
Glad you enjoyed it!😀
@@XLnCADMalayalam
435 minutes engeney 24 formatil akkan ulla formula paranju tharamo
Invoice formateil total amount - discount +vat engane yaanu formula kodikkunnd
രണ്ടു തിയ്യതികൾ തമ്മിൽ datedif ഫോർമുല ഉപയോഗിച്ച് - years /months/ days കാണുമ്പോള്
(Service :-
ex: From 03/01/2000 To 31/12/2000 and
From 05/06/2001 To 30/06/2001 =
0 years - 11 months - 29 days +
0 years - 0 months - 26 days = Total കാണുമ്പോൾ
0 years - 11 months - 55 days എന്ന് ലഭിക്കും.)
ഉത്തരം 1 year - 0 month - 25 days ഇങ്ങനെ ലഭിക്കാൻ എന്ത് ചെയ്യണം?
Oru company 5.50 am joliku vanna Al 6.4 pm poi 30 ദിവസം ഇത് thudarnnu എങ്കിൽ . അദ്ദേഹം total ethra hr duty ചെയ്തു . ഇന്ന് ഇങ്ങനെ excel calculate ചെയും
Is there any option to make a drop down list for time? (00:00 to 23:59)
കിട്ടിയോ എനിയ്ക്കും venam
Split ചെയ്യത Pdf file നെ excel/word sheet ലെ list of names കൊണ്ട് ഓരോ page ഉം rename ഒറ്റയടിക്ക് ചെയ്യാൻ പറ്റുമോ അങ്ങനെയെങ്കിൽ അത് ഒന്ന് പറഞ്ഞുതരാമോ
Thanks
My pleasure 😀
Useful tutorial
Glad you think so!
Really useful.
Glad you think so! :)
Really helpful😘😘
Glad it was helpful!
❤️
Good work
Thank you! Cheers!
👌👌👍✌
😀
Hello sir
The formula will be like as
12:00 PM
12:30 PM
1:00 PM
02:00 PM
03:00 PM
Is'nt it?
This is sabuchetten from
Saudi Arabia
Thank u very much.
Regards
Sabuchetten
ALKHOBAR
Please explain your doubt with more details.