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

Format the total cell as [h]:mm.

The brackets [ ] keep the hours from rolling over at intervals of 24.

Biff

"KRISSYBOY31" wrote in message
...
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