Re: calculating total time

Giganews Newsgroups
Subject: Re: calculating total time
Posted by:  via135 (via135.27i2tn_1147110902.1625@excelforum-nospam.com)
Date: Mon, 8 May 2006

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?action=getinfo&userid=26725
View this thread:http://www.excelforum.com/showthread.php?threadid=539940

Replies

None

In response to

calculating total time posted by bcamp1973 on Mon, 8 May 2006