Hi,
I have long list of data on usage (time on and off in a day) of 29 vehicles like below.
data.jpg
I would like to convert it into something like this: idea.jpg (a demo)
which shows whether it is occupied for each vehicle at any given time (in minute).
I am new to the forum and Excel so any advice will be very much appreciated.
Thanks a lot!
Bookmarks