Forum Discussion
Error subtracting times
The values in the Time Arrived and Time Out columns are left-aligned. This is usually a sign that Excel sees the values as text, not as real times. Insert a space between the time and the am/pm indication:
11:00 am
4:00 pm
Also, use =C4-B4 instead of =B4-C4.
If there is a chance that Time Out will be after midnight, use =MOD(C4-B4,1)
The values in the Time Arrived and Time Out columns are left-aligned. This is usually a sign that Excel sees the values as text, not as real times. Insert a space between the time and the am/pm indication:
11:00 am
4:00 pm
Also, use =C4-B4 instead of =B4-C4.
If there is a chance that Time Out will be after midnight, use =MOD(C4-B4,1)
- Ohhhh adding a space. that worked perfectly thanks for your assistance
Good day
It seems I am experiencing a similar problem.
I did what was said to the previous user, but I keep getting hashtags in the designated cells.
Even the same reference cell is/was being used - upon selecting the cell, the box turns red.
Even more strange, it was working perfectly on the right side of the spreadsheet, until I shifted to the left.
I made sure number format was the same for everything.
Thanks in advance
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
