Re: calculating total time

Giganews Newsgroups
Subject: Re: calculating total time
Posted by:  via135 (
Date: Mon, 8 May 2006


in C1:


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


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's Profile:
View this thread:



In response to

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