mrtechman
New Member
Hello All,
I am not a great expert in excel so this might sound a basic question to many but any help is highly appreciated. I have 2 Columns where in Col A I Have Timestamp in Hour basis and Another Column I have number of Sales. This data i have for 1 month. My Task is to do the SUM of Sales in Split Way. First is from Morning 9 AM to 1 PM and Second is 2 PM to 7 PM for every Day. Example of data below.
Col A COL B
2023/02/21 09:00:00 10
2023/02/21 10:00:00 100
2023/02/21 11:00:00 50
2023/02/21 12:00:00 40
Looking out for response. Many Thanks in Advance.
I am not a great expert in excel so this might sound a basic question to many but any help is highly appreciated. I have 2 Columns where in Col A I Have Timestamp in Hour basis and Another Column I have number of Sales. This data i have for 1 month. My Task is to do the SUM of Sales in Split Way. First is from Morning 9 AM to 1 PM and Second is 2 PM to 7 PM for every Day. Example of data below.
Col A COL B
2023/02/21 09:00:00 10
2023/02/21 10:00:00 100
2023/02/21 11:00:00 50
2023/02/21 12:00:00 40
Looking out for response. Many Thanks in Advance.