i have several thousand rows of data. Each row represents a task and includes the start time, end time, and data related to the task in the other columns. A task duration varies between 1 second to several minutes

I want to visualize how the tasks were scheduled over the data and any overlap that occured over a single day.

My spread sheet has this structure

start_timestamp, end_timestamp , ......more columns data.....
1562370607408   1562370607557    ..........
1562370509143   1562370509275    ..........
1562369706076   1562369706199    ..........

I was able to create spark lines per each row using this formula which gives a simple indicator based on the bar width of it's duration

=SPARKLINE({A5-$B$3,B5-A5},{"charttype" , "bar"; "color1" , "white"; "color2" , "red"; "max", $B$2-$B$3})

I'd like to be able to have an aggregated cell which shows the task scheduling during the full day (and periods when no work was done)

Is it possible?

migrated from superuser.com Jul 15 at 22:10

This question came from our site for computer enthusiasts and power users.

  • You want this to be done in google sheets, but tagged Excel? Which one is it? – JvdV Jul 15 at 20:14
  • share a copy of your sheet with example of desired output – user0 Jul 15 at 22:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy