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...
my advise so that it will work, whenever you have dates/time , dont make it text, change the format to date (right aligned should be) & then do any operations that you want, it will work
issue in your case is that you have your dates as text, so sum will give an error
issue in your case is that you have your dates as text, so sum will give an error