I am a newbie to excel and wouldn't be able to do anything like VBS that I saw mentioned in other posts that I read whilst trying to find an answer to this question...
I have patients who may have a reaction to a drug. The event will have a start date and time(A1) and a stop date and time(B1). I want to calculate the duration.
Initially I had both cells formatted as date with custom 'dd-mmm-yy hh:mm' and the calc as B1-A1 but if the month of start and finish is the same the result says that month is 1 when it should be zero.
Is that clear enough??
I have patients who may have a reaction to a drug. The event will have a start date and time(A1) and a stop date and time(B1). I want to calculate the duration.
Initially I had both cells formatted as date with custom 'dd-mmm-yy hh:mm' and the calc as B1-A1 but if the month of start and finish is the same the result says that month is 1 when it should be zero.
Is that clear enough??