MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 273|Reply: 7

Validate Email Subject [SOLVED]

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 9-20-2016 05:11:14 | All posts |Read mode
Please advise if the below is possible...

When I compose an new email, is it possible to verify if a particular text from the Subject is available in the body of the email before it is sent?
This would be of muccccch much help..  Looking forward for your kindly help
I use outlook - 2010
Reply

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 02:55:27 | All posts



Custo formatting
00\/00\/0000
will work if you enter it as an 8 digit number...











Reply Support Opposition

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 04:05:46 | All posts



Hi Glenn,
Can we do the same for Time, If I enter time it is currently showing 00:00:00
I want to enter just 700 and want system to identify it as 07:00 AM




Reply Support Opposition

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 04:32:09 | All posts



Hi Glenn,
Can we do the same for Time, If I enter time it is currently showing 00:00:00
I want to enter just 700 and want system to identify it as 07:00 AM




Reply Support Opposition

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 06:05:22 | All posts



The answer (as I should have said earlier) is yes - but only sort-of.
If you use custom formatting, your original number is still there 24112016 for today and 813 for the time of writing (08:13) if you use CF of 00\:00 for time.  Fine.  BUT.  You cannot use the numbers for ANY subsequent calculations.  the numbers just LOOK like dates and times to you.  42697 is Excel's way of referring to today (days since 0th Jan 1900) 24112016 is just being coerced to look like something that you recognise as a date.  If you want REAL dates times...  you'll need a formula in an adjacent cell to convert them.









Reply Support Opposition

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 07:20:33 | All posts



Of course, if its the CURRENT date/time that you're trying to enter:
CTRL and ; will enter the date and CTRL and : will enter the time.









Reply Support Opposition

Props Report

0

Topics

115

Posts

238

Integral

Conqueror

Rank: 3Rank: 3

Integral
238
Post on 11-25-2016 07:27:56 | All posts



Hi Glenn,
I am really confused with this date and time calculations
In the attached file i want to track number of minutes the activity was carried out. Using basic formulas there is some wierd output that excel throws. When the activity starts and end on same day the output is proper but as soon as the day changes, output is wrong.








  • Date and Time Diff.xlsx
    (9.1 KB, 15 views)
    Download








  • Reply Support Opposition

    Props Report

    0

    Topics

    115

    Posts

    238

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    238
    Post on 11-25-2016 08:26:11 | All posts
    Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-25-2017 11:44 , Processed in 0.207444 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!