Re: calculating total time

Giganews Newsgroups
Subject: Re: calculating total time
Posted by:  Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)
Date: Mon, 8 May 2006

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" <bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com> wrote
in message news:bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com...
>
> 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?action=getinfo&userid=32268
> 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