I hope that instead of =sum(A2-B2) you intended to say =A2-B2 ?
If not, what is the SUM function doing for us in that formula?
--
David Biddulph


"FSt1" wrote in message
...
hi
do you mean subtract or add??
=sum(A2-B2) or +
just remember that excel keeps track of time as a percent of a day.
12 noon is .5 day. enter 7:00 in one cell and 5:45 in another. reformat to
general. these are the accual numerical values that excel is seeing.
formating doesn't change data, it just changes the way it looks on the
sheet.

regards
FSt1

"gma" wrote:

if i enter "7:00 am in one cell and 5:45 pm in another cell, what formula
do
in enter in another cell to caluclate the time?