cell formating

[Guest]

I want to have 2 columns one headed start and the other finish.
In the start column I will be inputing dd/mm and the time in 24hour format i.e 05:00
In the finish column it will be the same apart from the time that will be later and could possibly be the next day say 01:00
(20 hours).
I will have a 3rd column that will show the total hours from start to finish.
At the bottom of the 3rd column will be a weekly total of all the hours.
So far I have formatted the cells in the 3rd column and it is showing me the hours worked, but I cannot seem to get the weekly total cell to format,if I try the normal sum command it spits out strange amounts. What formula's should I be putting into the relevant cells? Maybe I have formatted all the cells wrong.

Bobby

 

[J.E. McGimpsey]

The fomrats for the sum, and possibly the entire finish column,
should be

Format/Cells/Number/Custom [h]:mm

which prevents time's "rolling over" after 24 hours.