Feb 15 2021 08:33 AM
Feb 15 2021 08:48 AM
If you need the numbers for calculations, you'd have to format each cell individually the way you want - not an attractive idea.
If not, you could format the relevant cells as Text. The cell value will then be exactly what you enter. But functions such as SUM and AVERAGE will ignore the values.
Feb 15 2021 08:56 AM - edited Feb 15 2021 08:57 AM
I am keeping track of time in 1/4 of an hour increments. So, I like for one hour to look like: 1.0 And, an hour and fifteen minutes to look like: 1.25 But, I don't like the extra "0" of 1.00 or 1.50 Does that make sense?