Im trying to write a new sheet to log hours for calls so that I can claim all hours worked whilst on call back.
I have a cell with a time format in that i use to enter the time when the call is logged, i then have another cell in time format to log when the call was finished, a third cell calculates the time of the call (all pretty straight forward so far).
basically, I have time restrictions on the hours that I am allowed to claim back. This being for example, not being allowed to claim back any hours worked before 10pm.
I am trying to write an if statement that will first look at the time in Cell 1 and check that it is before 10pm, the result being automatically 0 as this is before claimable time. If after 10pm, to just display the amount of time owed. Im struggling with what to put in as my actual criteria
I had tried If(Cell1>10:00, Cell3, 0) this was just a basic start which i realised failed as in excel 10:00 is acutally specifying a range, when i tried with just the number 10 in, it brought me back the answer as 0.
Is it possible to work with Time regarding if statements or is there a better way I could go about this.
Thank you very much Colin, that does pretty much what I am after, with a little tweaking I will be able to get it to fit my needs perfectly (there is nothing wrong with your statement, I just have a few more contraints thats all).
On a side not, i know the solution you gave me works for calls between 10pm and Midnight, basically, my on call rota goes from 5:30pm-8:00am the following morning. Of these hours I am only able to claim back time from 10:00pm-8:00am
I am now thinking that the calculations I was after are not possible, but if there is a solution to that problem, I would highly appreciate it.