Using the following;
C1 is formatted in dd/mm/yyyyy h:mm entered value is 15/4/2008 8:00. This is
commencement of work.
D1 is formatted in dd/mm/yyy h:mm entered value is 18/4/2008 10:00. This is
end of work.
In E1 I would like to calculate the total hours worked giving the answer in
days and hours. Note the working day is 7 hours 30 min long.
Thanks in advance