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...
Your formula should be:
=SUM(DeckLog[Arrival Date/Time]-DeckLog[Departure Date/Time])
Your values in "Time Underway" are text. Text will be ignored in SUM().
And you formula in "Time" does not need the SUM() function.
- Detlef,
The formula you provided looks exactly the same as one I was using.
=SUM(DeckLog[Arrival Date/Time]-DeckLog[Departure Date/Time])
It still isn't working.
Any ideas?
George
