Help with Room Utilization Grid

D

debmullin

New Member
Joined
May 3, 2019
Messages
3
Hi - I have data that represents classes assigned to a room. Some classes are two days a week, some classes are 1 day a week. I would like to have a visual of the room utilization and open slots. I tried a pivot table with class start and stop time as a row and Class Day as a column. That doesn't seem to do it. Anyone have an idea for a grid. Here is a sample of one of the rooms with fake instructor names:

[TABLE="width: 551"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Class Day[/TD]
[TD]CATALOG #[/TD]
[TD]CLASS SECTION[/TD]
[TD]Room[/TD]
[TD]Instructor [/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]T[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]R[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]9:30 AM[/TD]
[TD="align: right"]12:15 PM[/TD]
[TD]F[/TD]
[TD] 1A[/TD]
[TD]78[/TD]
[TD]BBC121[/TD]
[TD]Ana Romero[/TD]
[/TR]
</tbody>[/TABLE]

And this is what I want it to look like:

[TABLE="width: 655"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]M
[/TD]
[TD]T
[/TD]
[TD]W
[/TD]
[TD]R
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]9:00 AM-10:15AM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Holmes 1A-78 9:30 - 12:15
[/TD]
[/TR]
[TR]
[TD]10:30 AM - 11:45 AM
[/TD]
[TD]
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[/TR]
[TR]
[TD]12:00 PM - 1:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[/TR]
[TR]
[TD]1:30 PM - 2:45 PM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 PM - 4:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:30 PM - 5:45 PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]


Thanks for any advice![/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
is that what you want ?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#FFFF00]Source[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#FFFF00]Result[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Start Time[/td][td=bgcolor:#5B9BD5]End Time[/td][td=bgcolor:#5B9BD5]Class Day[/td][td=bgcolor:#5B9BD5]CATALOG #[/td][td=bgcolor:#5B9BD5]CLASS SECTION[/td][td=bgcolor:#5B9BD5]Room[/td][td=bgcolor:#5B9BD5]Instructor[/td][td][/td][td=bgcolor:#70AD47]Time[/td][td=bgcolor:#70AD47]M[/td][td=bgcolor:#70AD47]T[/td][td=bgcolor:#70AD47]W[/td][td=bgcolor:#70AD47]R[/td][td=bgcolor:#70AD47]F[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
10:30 AM​
[/td][td=bgcolor:#DDEBF7]
11:45 AM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
10​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td=bgcolor:#E2EFDA]09:00 - 10:15[/td][td=bgcolor:#E2EFDA]Roth 1A-69[/td][td=bgcolor:#E2EFDA]Hampton 1AF-6[/td][td=bgcolor:#E2EFDA]Roth 1A-69[/td][td=bgcolor:#E2EFDA]Hampton 1AF-6[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12:00 PM​
[/td][td]
1:15 PM​
[/td][td]M[/td][td]
2​
[/td][td]
13​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td]09:30 - 12:15[/td][td][/td][td][/td][td][/td][td][/td][td]Romero 1A-78[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
3:00 PM​
[/td][td=bgcolor:#DDEBF7]
4:15 PM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
21​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td=bgcolor:#E2EFDA]10:30 - 11:45[/td][td=bgcolor:#E2EFDA]Kim 2-10[/td][td=bgcolor:#E2EFDA]Holmes 1A-26[/td][td=bgcolor:#E2EFDA]Kim 2-10[/td][td=bgcolor:#E2EFDA]Holmes 1A-26[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4:30 PM​
[/td][td]
5:45 PM​
[/td][td]M[/td][td]
2​
[/td][td]
24​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td]12:00 - 13:15[/td][td]Kim 2-13[/td][td]Holmes 1A-42[/td][td]Kim 2-13[/td][td]Holmes 1A-42[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
1:30 PM​
[/td][td=bgcolor:#DDEBF7]
2:45 PM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
49​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Raleigh Roth[/td][td][/td][td=bgcolor:#E2EFDA]13:30 - 14:45[/td][td=bgcolor:#E2EFDA]Roth 1A-49[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]Roth 1A-49[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9:00 AM​
[/td][td]
10:15 AM​
[/td][td]M[/td][td]1A[/td][td]
69​
[/td][td]BBC121[/td][td]Raleigh Roth[/td][td][/td][td]15:00 - 16:15[/td][td]Kim 2-21[/td][td][/td][td]Kim 2-21[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:00 AM​
[/td][td=bgcolor:#DDEBF7]
10:15 AM​
[/td][td=bgcolor:#DDEBF7]T[/td][td=bgcolor:#DDEBF7]1AF[/td][td=bgcolor:#DDEBF7]
6​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Abe Hampton[/td][td][/td][td=bgcolor:#E2EFDA]16:30 - 17:45[/td][td=bgcolor:#E2EFDA]Kim 2-24[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]Kim 2-24[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10:30 AM​
[/td][td]
11:45 AM​
[/td][td]T[/td][td]1A[/td][td]
26​
[/td][td]BBC121[/td][td]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
12:00 PM​
[/td][td=bgcolor:#DDEBF7]
1:15 PM​
[/td][td=bgcolor:#DDEBF7]T[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
42​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10:30 AM​
[/td][td]
11:45 AM​
[/td][td]W[/td][td]
2​
[/td][td]
10​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
12:00 PM​
[/td][td=bgcolor:#DDEBF7]
1:15 PM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
13​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3:00 PM​
[/td][td]
4:15 PM​
[/td][td]W[/td][td]
2​
[/td][td]
21​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
4:30 PM​
[/td][td=bgcolor:#DDEBF7]
5:45 PM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
24​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1:30 PM​
[/td][td]
2:45 PM​
[/td][td]W[/td][td]1A[/td][td]
49​
[/td][td]BBC121[/td][td]Raleigh Roth[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:00 AM​
[/td][td=bgcolor:#DDEBF7]
10:15 AM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
69​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Raleigh Roth[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9:00 AM​
[/td][td]
10:15 AM​
[/td][td]R[/td][td]1AF[/td][td]
6​
[/td][td]BBC121[/td][td]Abe Hampton[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
10:30 AM​
[/td][td=bgcolor:#DDEBF7]
11:45 AM​
[/td][td=bgcolor:#DDEBF7]R[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
26​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12:00 PM​
[/td][td]
1:15 PM​
[/td][td]R[/td][td]1A[/td][td]
42​
[/td][td]BBC121[/td][td]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:30 AM​
[/td][td=bgcolor:#DDEBF7]
12:15 PM​
[/td][td=bgcolor:#DDEBF7]F[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
78​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Ana Romero[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]
 
Upvote 0
with M-code (PowerQuery)

Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Start Time", type time}, {"End Time", type time}, {"Class Day", type text}, {"CATALOG #", type any}, {"CLASS SECTION", Int64.Type}, {"Room", type text}, {"Instructor", type text}}),
    MergeCatClass = Table.CombineColumns(Table.TransformColumnTypes(Type, {{"CATALOG #", type text}, {"CLASS SECTION", type text}}, "en-GB"),{"CATALOG #", "CLASS SECTION"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Merged"),
    Split = Table.SplitColumn(MergeCatClass, "Instructor", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Instructor.1", "Instructor.2"}),
    MergeInstrCatClass = Table.CombineColumns(Split,{"Instructor.2", "Merged"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged.1"),
    Pivot = Table.Pivot(MergeInstrCatClass, List.Distinct(MergeInstrCatClass[#"Class Day"]), "Class Day", "Merged.1"),
    MergeTime = Table.CombineColumns(Table.TransformColumnTypes(Pivot, {{"Start Time", type text}, {"End Time", type text}}, "en-GB"),{"Start Time", "End Time"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Time"),
    GrpTime = Table.Group(MergeTime, {"Time"}, {{"Count", each _, type table}}),
    ExtractM = Table.TransformColumns(Table.AddColumn(GrpTime, "M", each List.Distinct(Table.Column([Count],"M"))), {"M", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractT = Table.TransformColumns(Table.AddColumn(ExtractM, "T", each List.Distinct(Table.Column([Count],"T"))), {"T", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractW = Table.TransformColumns(Table.AddColumn(ExtractT, "W", each List.Distinct(Table.Column([Count],"W"))), {"W", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractR = Table.TransformColumns(Table.AddColumn(ExtractW, "R", each List.Distinct(Table.Column([Count],"R"))), {"R", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractF = Table.TransformColumns(Table.AddColumn(ExtractR, "F", each List.Distinct(Table.Column([Count],"F"))), {"F", each Text.Combine(List.Transform(_, Text.From)), type text})
in
    ExtractF[/SIZE]
 
Upvote 0
Another Power Query solution. Different approach, same results.

Code: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start Time", type time}, {"End Time", type time}, {"Class Day", type text}, {"CATALOG #", type text}, {"CLASS SECTION", type text}, {"Room", type text}, {"Instructor", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Instructor", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Instructor.1", "Instructor.2"}),
    #"Added Custom" = Table.AddColumn(#"Split Column by Delimiter", "Custom", each [Instructor.2] & " " & [#"CATALOG #"] & "-" & [CLASS SECTION]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"CATALOG #", "CLASS SECTION", "Room", "Instructor.1", "Instructor.2"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[#"Class Day"]), "Class Day", "Custom"),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,"",Replacer.ReplaceValue,{"M", "T", "W", "R", "F"}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Replaced Value", {{"Start Time", type text}, {"End Time", type text}}, "en-US"),{"Start Time", "End Time"},Combiner.CombineTextByDelimiter(" to ", QuoteStyle.None),"Time")
in
    #"Merged Columns"
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Possible to pull apart 1st section of string for date & time
2 3
Replies
23
Views
511
Peter_SSs
Peter_SSs
A
  • Solved
Calculate monthly booked percentage of hotel rooms
2 3
Replies
21
Views
340
arendberg
A
J
  • Question Question
XLOOKUP, Finding a Value based on Time and Date
Replies
1
Views
378
SunnyAlv
SunnyAlv
J
  • Question Question
Finding Numbers from a Column Using Target Numbers
2
Replies
11
Views
431
Cubist
Cubist
S
  • Question Question
How do I store a battery's state of charge past midnight?
Replies
3
Views
253
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top