How to create a query that pulls the following fields from each event?

[Strangertinz]

Can anyone offer some guidance on how to go about creating a query that pulls the following fields from each event 

Start_time (date and time ) — different from _time field 

End_time (date and time ) — different from _time field 

usage_amount ( a whole number) 

I will like to calculate the time difference between the start and end time and split every event that the start and end time span over one day and split the original event into multiple individual events where each event from the search just returns the modified list of events where the start and end times are within the same day 

[Strangertinz]

Thanks, I posted some pictures of the data/current SPL query. Let me know if I can provide anything else 

[Strangertinz]

I attached some picture of the sample data and query thus far

[ITWhisperer · Accepted solution]

Try something like this

[Strangertinz]

This is awesome! Thanks !!!

[yuanliu]

You want to start by telling the community about your data. (Anonymize as needed.)  How do you determine what is Start_time, what is End_time, what is usage_amount, etc.?  SPL is just a tool.  Until you can show volunteers how you do it without SPL, we cannot help you craft SPL.