Forum Discussion

Lawyer11's avatar
Lawyer11
Copper Contributor
Feb 16, 2025

Clock time timeline and elapsed time

Hi Everyone, I need to create a timeline where a minute-by-minute timeline shows both the actual clock time and the time elapsed.  Could anyone point me to a good resource or template?     Thanks,...
Formulas and Functions
office 365
training
HansVogelaar's avatar
HansVogelaar
MVP
Feb 18, 2025

Could you attach a sample workbook that shows what you want to do, or make it available on Onedrive, Google Drive, Dropbox or similar?

  • Lawyer11's avatar
    Lawyer11
    Copper Contributor
    Feb 20, 2025

    Hans, thank you.  

    I need to create a timeline, starting with the actual time beginning until the actual time end, like 1600-1620, as in the drawing.  

    Then, on the horizontal axis, I have all the responding departments and their corresponding units.  I need to keep track of the times and events that each unit completed, and at what time.  

    I want each unit "contiuum bar" to be colored seperately for each unit.  

    Finally, I would like a "time lapsed" counter for each unit.  Ex:  If a unit was dispatched at 1600 and cancelled at 1605, there would be a five minute time lapse.  

    I am attaching a drawing, and also an Excel spreadsheet that I have tried to cobble together.  I am open to any and all suggestions and help!  

    Thank you very, very much, Hans.  

    Warmest,

    Tim

    https://drive.google.com/file/d/1ejdxHVZox3F2tUNLFZCvB0Ehy9GFkgGc/view?usp=sharing

    https://docs.google.com/spreadsheets/d/1flT96OeoPJ6tmEOGayf22uacihuyvx3G/edit?usp=sharing&ouid=109317898822402526577&rtpof=true&sd=true

    https://drive.google.com/file/d/1NwG-IRxtrsS580RDAzccxtuu09fmPPdi/view?usp=sharing

    I added a screenshot of the actual Excel sheet because the chart did not show up on the Google Sheets transfer.  

Resources