Problem subtracting 2 dates

[Mackeral]

I have a speed sheet that has 2 dates on each row which are subtracted and the ndisplayed.

When I put the dates in under programmatic control it works.
Sometimes though, I need to enter one of the dates manually., and when I do the subtraction answer always displays "#VALUE!".
If I "Typename" all three of the date cells, they all say "Range".
The beginning date is "9/23/24 11:40" and the ending date is "9/2/24 12;00", and I am subtracting the beginning date from the ending date.

I am pretty sure it's the Start Date that's causing the error, but explicitly reformatting it to "m/d/yy hh:mm" doesn't fix it.

Any idea about what is going on?

Mac

 

[RoryA]

Two obvious issues are that the end date is before the start date, and you have a semi colon in the time value instead of a colon.

As a side observation, it would be nice if you actually responded to the comments in your other threads or you may find people stop trying to help...