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 

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