On Tue, 13 Sep 2005 06:45:03 -0700, tankerman
wrote:

In excel I have to keep start and finish times for different product
movements, I am constantly figuring the # of hours and mins. EXAMPLE start
date 8/12/2005 time 13:15, finish date 8/13/2005 time 05:35 equals 16 hrs and
20 minutes. Can excel figure this for me or am I out of luck.


A1: 8/12/2005 13:15
A2: 8/13/2005 05:35

A3: =A2-A1
Format/Cells/Number/Custom Type: [h]:mm

Note the brackets around the 'h'. This allows display of hours 24.


--ron