Forum Discussion
Solved
Excel doesn't calculate time (#value error) when past 13:00.
I need help to correct an #value error. My calculations work perfectly fine when I subtract one time cell from another except when the time is past 13:00. I tried changing the cell function to genera...
I believe excel is not recognizing those cells as time since 13:06 PM is not normal. it is either 13:06 OR 1:06 PM. If you remove the PM it should work (it did for me)
Thank you