Re: calculating total time

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


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


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


Returns 5:20


"bcamp1973" <> wrote
in message
> 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:
> View this thread:


In response to

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