how can i get the date & time format 2010/02/17 12:05 in excel

Posted to microsoft.public.excel.misc

Jacob Skaria Jacob Skaria is offline

external usenet poster

Posts: 8,520

how can i get the date & time format 2010/02/17 12:05 in excel

Try
=SUMPRODUCT((TEXT(I3:I71,"mmyyyy")="032010")*(H3:H 71))

--
Jacob

"NarenSelva" wrote:

I would like to share my knowledge by improving & clearing my doubts.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting text format of time/date into Excel time/date for subtr	YY san.[_2_]	Excel Worksheet Functions	6	February 25th 10 08:27 AM
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM	Peter Gonzalez[_2_]	Excel Worksheet Functions	2	January 26th 10 06:58 PM
data label format not saving in excel 2010	Will	Charts and Charting in Excel	0	January 13th 10 04:23 PM
2010 date in Excel 2000	BudW	Excel Discussion (Misc queries)	2	January 5th 10 04:59 PM
How do I get Excel to drop the date from a time format?	lozzielou	Excel Discussion (Misc queries)	1	November 2nd 09 08:29 AM

All times are GMT +1. The time now is 09:14 AM.

Menu

About Us