Report

# Working out the difference in times between two columns [Solved]

Ask a question
sailingdemon
11Posts
Thursday September 28, 2017Registration date
November 13, 2017
Last seen
- Last answered on Nov 12, 2017 at 11:41 AM by sailingdemon

Rather than nesting I am testing each part of the formula and building it up in columns, once working in their individual components I will try and nest them. So far I have got this:

=IF(AND(A1<=12,A1>=7),1,0) In C1

=IF(AND((A1<18.9,A1>12),2,0) in D1

I can get this to work with basic numbers.

I have tried substituting 12 with 00:00 as I work in 24Hr clock, or 7 with 07:00 (when doing this I have added a $ sign in front of the cell reference) and I get an error message thrown back.

Any ideas please?

Thank you anyway, Simon

Any help greatly appreciated.

Thank you,

Simon