Question: In column A are some things that look like datetimes (but are actually text) that were exported from some information system. You'd like to figure

In column A are some things that look like datetimes (but are actually text) that were exported from some information system. You'd like to figure out which half hour "bin" of the day each of these timestamps falls into. In column B I'm showing you what the answer looks like. You'll notice that a time bin of 8:30 means that the timestamp was between 8:30-9:00 (left inclusive, right not inclusive). You should also note that the values in column B are valid Excel time values - they are NOT text. Your job is to create a formula in column C that returns the correct Excel time bin as shown in column B. Obviously you CANNOT use column B in your formula; you can only use column A. Your formula MUST return an Excel time value, NOT text.

TextDateTime	excel_time_bin	Your formulas
01-JUN-2018 08:36 AM	8:30
01-JUN-2018 08:37 AM	8:30
02-JUN-2018 11:55 AM	11:30
02-JUN-2018 15:47 PM	15:30
03-JUN-2018 10:35 AM	10:30
03-JUN-2018 18:36 PM	18:30
03-JUN-2018 20:42 PM	20:30
03-JUN-2018 23:44 PM	23:30
04-JUN-2018 19:12 PM	19:00
05-JUN-2018 04:20 AM	4:00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In column A are some things that look like datetimes that were exported from some information system. You'd like to figure out which half hour "bin" of the day each of these timestamps falls into. In...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Why Uber Is an Economist's Dream Does 'surge pricing'...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Using Big Data to Estimate Consumer Surplus: The Case of Uber...

Providing Quality School-Based Learning and Support Services 239 Chapter 6 Language and literacy support Your core task The core task of almost all TAs is to support students language and literacy...

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

Confirming Pages C H A P T E R 19 Analyzing Information and Writing Reports Chapter Outline Using Your Time Efficiently Analyzing Data and Information for Reports Identifying the Source of the Data...

1. What were the three key elements that were part of Buck Knives' five-year plan to reduce costs? Which one did they implement immediately? 2. There were some key executive-level managers who became...

6 | Consumer Choices Figure 6.1 Investment Choices Higher education is generally viewed as a good investment, if one can afford it, regardless of the state of the economy. (Credit: modification of...

Give example of insert operation that violates key constraint 2- Give example of delete operation that violates referential integrity constraint 3- Give example of update operation that violates...

What are the major principles of social marketing?

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Pizza Vesuvio above. Assume that this information was used to construct the...

Baseline Performance Why is the measurement of baseline performance important? What are some of the more frequently used baseline performance measures? How are they different from each other and when...

2. Contrast the older and the modern views of technological advance as they relate to the economy. What is the role of entrepreneurs and other innovators in technological advance? How does research...

LO15.3 Summarize how a firm determines its optimal amount of research and development (R&D).

LO15.5 Relate why firms can benefit from their innovation even though rivals have an incentive to imitate it.