Why are cells that I want to remain formatted as 'durations' automatically converting to 'numbers'?
First, I appreciate your time.
Second, the issue and question:
I am creating a running total for time entrances based on specific jobs. In 2 different cells, on the same row, I am entering my time (in 0:00 format) when I start and finish a specific job. In another cell, the duration for that "job" is calculated, on that same row. At the bottom of these "duration" calculations for the specific jobs, are the SUMS of said "durations" giving me a total amount of hours worked during the week. There is an issue with the "SUM action". Here is a picture to help visualize.
My problem is: The durations are converting over to numbers automatically and disrupting the ability to sum (green box) when I do not have times entered into the "work hours" (start and finish) categories. I would much rather the SUM not factor in the cells without entries and continue to do it's work with the cells that do have entries giving me a total number of hours worked whether I use all of the rows or not.
How do I accomplish this?
MacBook Pro (2020 and later)
