Forum Discussion

Todd Lane's avatar
Todd Lane
Brass Contributor
Apr 14, 2023
Solved

Calculate Stop times

Hi, Think bus timetable. I have a cell with formatted as a Time cell. Currently showing 8:00am   I also have a column formatted as hh:mm which shows a series of durations 2:13 (2 hours 13 mins) ...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 14, 2023

    Todd Lane 

    The duration cells are formatted as hh:mm, and the start and stop times as h:mm AM/PM.

    I have attached a sample workbook.

HansVogelaar's avatar
HansVogelaar
MVP
Apr 14, 2023

Todd Lane 

For example (result to the left, formulas to the right):

Or even easier:

  • Todd Lane's avatar
    Todd Lane
    Brass Contributor
    Apr 14, 2023

    Thanks HansVogelaar,

    Im not getting same results. Would you mind sharing what format you are using on each cell

     

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Apr 14, 2023

      Todd Lane 

      The duration cells are formatted as hh:mm, and the start and stop times as h:mm AM/PM.

      I have attached a sample workbook.

Resources