time function

[axiom]

cen anybody help mi how to calculate
in first row theres lets say time when started something in hour- minutes
format
in second row time when finished also in hh.mm format
in third row i would like to see the difference i.e. time used or spent and
the sum of that row

im using excell 2oo3

thanks

 

[Frank Kabel]

Hi
if column A conatins the start time and column B the end time use the
following formula in C1:
=B1-A1
and if your working time can span midnight use
=B1-A1+(B1<A1)
format this cell also as time

To sum these values use something like
=SUM(C1:C10)
and format this cell with the custom format
[hh]:mm