software

I have two fields quot;start timequot; and quot;end timequot; for tracking my time on
projects. on each line next to those fields i'd like to add a quot;totalquot;
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: www.excelforum.com/member.php...oamp;userid=32268
View this thread: www.excelforum.com/showthread...hreadid=539940
hi!

in C1:

=B1-A1

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

-via135
bcamp1973 Wrote:
gt; I have two fields quot;start timequot; and quot;end timequot; for tracking my time on
gt; projects. on each line next to those fields i'd like to add a quot;totalquot;
gt; field that automatically calculates the total time in hours and
gt; minutes. I thought there might be a function for this already, but i'm
gt; not finding it in the help files...any suggestions?--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539940Hi!

Just subtract the start time from the end time:

A1 = start time = 7:30 AM
B1 = end time = 5:45 PM

Format the cell as [h]:mm

=B1-A1

Returns 10:15

If the times might span past midnight use this formula:

A1 = start time = 10:00 PM
B1 = end time = 3:20 AM

=B1-A1 (B1lt;A1)

Returns 5:20

Biff

quot;bcamp1973quot; gt; wrote
in message ...
gt;
gt; I have two fields quot;start timequot; and quot;end timequot; for tracking my time on
gt; projects. on each line next to those fields i'd like to add a quot;totalquot;
gt; field that automatically calculates the total time in hours and
gt; minutes. I thought there might be a function for this already, but i'm
gt; not finding it in the help files...any suggestions?
gt;
gt;
gt; --
gt; bcamp1973
gt; ------------------------------------------------------------------------
gt; bcamp1973's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32268
gt; View this thread: www.excelforum.com/showthread...hreadid=539940
gt;
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

nwexcelsolutions.comquot;bcamp1973quot; gt; wrote
in message ...
gt;
gt; I have two fields quot;start timequot; and quot;end timequot; for tracking my time on
gt; projects. on each line next to those fields i'd like to add a quot;totalquot;
gt; field that automatically calculates the total time in hours and
gt; minutes. I thought there might be a function for this already, but i'm
gt; not finding it in the help files...any suggestions?
gt;
gt;
gt; --
gt; bcamp1973
gt; ------------------------------------------------------------------------
gt; bcamp1973's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32268
gt; View this thread: www.excelforum.com/showthread...hreadid=539940
gt;

Perfect, thanks everyone!--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: www.excelforum.com/member.php...oamp;userid=32268
View this thread: www.excelforum.com/showthread...hreadid=539940