Calcualting and Adding Time Values in Exc 2003

[Guest]

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

 

[Bob Flanagan]

To format as delta time in hours:minutes, use

[h]:m

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel