T
Trevor Aiston
I have a worksheet which I can correctly add/subtract time vaues. But
whenever I try and add/sum reults I do not get the answer in either hrs or
hours and mins
see below
Week Day Date Start End HOURS
40 1 01/10/2007 08:30:00 16:30:00 08:00
40 2 02/10/2007 08:30:00 16:30:00 08:00
40 3 03/10/2007 08:45:00 16:30:00 07:45
40 4 04/10/2007 08:30:00 16:00:00 07:30
40 5 05/10/2007 09:00:00 15:00:00 06:00 1.55
13:15:00
Any advice guidance apprecaitted
whenever I try and add/sum reults I do not get the answer in either hrs or
hours and mins
see below
Week Day Date Start End HOURS
40 1 01/10/2007 08:30:00 16:30:00 08:00
40 2 02/10/2007 08:30:00 16:30:00 08:00
40 3 03/10/2007 08:45:00 16:30:00 07:45
40 4 04/10/2007 08:30:00 16:00:00 07:30
40 5 05/10/2007 09:00:00 15:00:00 06:00 1.55
13:15:00
Any advice guidance apprecaitted