I am creating a spreadsheet to track my time and hours worked. I have my Start Time and my End Time in h:mm AM/PM format, I then have a column for total hours worked in hh:mm format. Something like this: Column A 9:00 AM, column B 4:30 PM, and my total hours worked column = 7:30 (meaning 7.5 hours worked) my formula there is =B1-A1. I am getting the duration of time lapsed between 9am and 4:30pm. That's fine.
My question is, I want my column B to default to PM so I don't have to type it. When I change the format to show PM, it puts it in military time. I want standard time. So, I did a custom format of h:mm "PM". That didn't work. It turned my "total hours worked" column into this ############### value. Can I have both, standard time and my duration of time formula?