hi!

in C1:

=B1-A1

where endtime & start time in B1 & A1 respectively
and format C1 Custom [hh]:mm

-via135



bcamp1973 Wrote:
I have two fields "start time" and "end time" for tracking my time on
projects. on each line next to those fields i'd like to add a "total"
field that automatically calculates the total time in hours and
minutes. I thought there might be a function for this already, but i'm
not finding it in the help files...any suggestions?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539940