I have a time sheet which has Monday to Sunday with a start time and end time
with the cells fromatted "Custom: hh:mm AM/PM", therefore 9:00 displays as
09:00 AM.
In a calculation for each day I have end time - (minus) start time which
gives a correct daily total in a cell formatted "Custom: h:mm".

However, when I try to 'sum' the daily total at the bottom of the worksheet
i.e. the weekly total, it totalises the code rather than the value. If the
total for each day is 7:00 hrs, the sum for Monday to Sunday, instead of
being 49:00, using =sum() gives a value of 01:00.

Any help would be appreciated
--
regards,
Krissyboy31