calculating total time

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?

hi!

in C1:

=B1-A1

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

-via135

Originally Posted by bcamp1973

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?

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Hi!

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+(B1<A1)

Returns 5:20

Biff

"bcamp1973" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Perfect, thanks everyone!