I need help to see how to get a formula for this.

if a person signed on at 10:22 am and finished at 4:45, how can i get the
excel sheet to tell me how much time was used on the project? I am a real
novice, so really simple explainations would be greatly appreciated. I
checked all of the ones available on here on the online discussion, but was
lost all the way through.
simply stupid I guess.
thanks
Sandra

=end time - start time

format cell as h:mm


"Novice-Sandra" wrote:

> I need help to see how to get a formula for this.
>
> if a person signed on at 10:22 am and finished at 4:45, how can i get the
> excel sheet to tell me how much time was used on the project? I am a real
> novice, so really simple explainations would be greatly appreciated. I
> checked all of the ones available on here on the online discussion, but was
> lost all the way through.
> simply stupid I guess.
> thanks
> Sandra

Times and dates in Excel are just formatted numbers. Dates to the left
of the decimal and times to the right.
With 10:22 AM in A1 and 4:45 PM in B1, the formula in C1 would be:
=B1-A1
Excel will automatically format the result as AM/PM time - just change
the format to something that doesn't have AM/PM included like h:mm;@.

To demonstrate the simplicity, format all the cells as general -
4:45 PM = 0.697916667
minus
10:22 AM = 0.431944444
equals
6:23 = 0.265972222

Excel won't display negative time values - you'll get a cell full of
#######.
Other than that, there's nothing special about the math, it's all in
the formatting with times and dates.

Cliff Edwards