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.

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