Times in excel is just numbers so to get total time jus subtract
=B1-A1
where A1 is start and B1 end, if more than 24 hours use a custom format of
[hh]:mm
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"bcamp1973" wrote
in message ...
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?
--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile:
http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=539940