I tried the first example you gave =A1-TIME(5,0,0) - however my result is
########## that no matter how wide I make the column it keeps doing that. I
got the same result with your second suggestion. Do I need to select a
different time format?
Sorry - If you're using the WinXL default 1900 date system, that
indicates that the result is negative, and that date system can't
display negative times.
Bingo! That worked great - thank you for your help.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.