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?

On Sun, 7 Mar 2010 11:04:01 -0800, 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?

If the first cell is A1 and the other cell is A2, try the following
formula in a third cell:

=A2-A1

Format the third cell to display the time difference the way you like.

Hope this helps / Lars-Åke

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?

What value is using Sum? And if you're subtracting times, you want the
result formatted as a time, not General.

Regards,
Fred

"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?

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?

hi
i was trying to illistrate a point about the real values behind the formated
times. obviously one would want the value formated as time but it does help
to know what is going on behind the formating ie it's not hocos pocus. it's
simple math using real numbers simply formated to look another way.

regards
FSt1

"Fred Smith" wrote:

What value is using Sum? And if you're subtracting times, you want the
result formatted as a time, not General.

Regards,
Fred

"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?

.

hi
it works either way. omitting the sum does reduce typing.

regards
FSt1

"David Biddulph" wrote:

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?


.

All
Let me try this way
cell one: 06:00 am
cell two: 02:30 pm
cell three: formula/calculating cell: 8.5 hours
when i change the numbers in the either cell one or two it changes cell
three to what ever time differance, + or -

"Lars-Ã…ke Aspelin" wrote:

On Sun, 7 Mar 2010 11:04:01 -0800, 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?

If the first cell is A1 and the other cell is A2, try the following
formula in a third cell:

=A2-A1

Format the third cell to display the time difference the way you like.

Hope this helps / Lars-Ã…ke

.