Time Analysis
I want to give a value of 1 for emails that are received before 6:00 AM or
after 7:30 PM. The email data was copied from Outlook and pasted into Excel which have the Sender, Subject, Date, and Time in seperate columns. How do I analyze time data? |
One way:
To give a value of 1 for each entry (assume Time in column D): =--OR(D1<TIME(6,0,0), D1TIME(19,30,0)) and copy down. To get just a total: =SUMPRODUCT((rng<TIME(6,0,0))+(rngTIME(19,30,0))) In article , Mark T <Mark wrote: I want to give a value of 1 for emails that are received before 6:00 AM or after 7:30 PM. The email data was copied from Outlook and pasted into Excel which have the Sender, Subject, Date, and Time in seperate columns. How do I analyze time data? |
All times are GMT +1. The time now is 02:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com