Forum Discussion
Summing Time Periods in a Table Using Structural References
I have a table in a spreadsheet where I enter data pertaining to my ship voyages. There is a column for departure day/time and another for arrival day/time. I am trying to sum the number of hours a...
The image shows some formulae (red) that do work for the reasons explained by others. The number formatting required to show the time underway is not straightforward, and uses
d "days," h "hours, "
m "minutes"
where the linefeed is inserted using Ctrl/J