Excel doesn't calculate time (#value error) when past 13:00.

Question

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 general, number, custom but nothing seems to work unless I manually change the time to 1:00pm.&nbsp; Thoughts?&nbsp; TIABelow is an example:Cell AB&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cell AD8:15&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08:29 AM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:1413:06 PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13:54 PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #VALUE!&nbsp;=SUM(AD2-AB2) is the formula I am using

m_tarler · Accepted Answer

I believe excel is not recognizing those cells as time since 13:06 PM is not normal.&nbsp; it is either 13:06 OR 1:06 PM.&nbsp; If you remove the PM it should work (it did for me)

Forum Discussion

Excel doesn't calculate time (#value error) when past 13:00.

2 Replies

Resources