Enter the date and time data in one cell as eg 8/12/2005 13:15 then subtract
one from the other. Format the cell as hh:mm
--
Ian
--
"tankerman" wrote in message
...
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.
|