calculating clock times

  • Thread starter Thread starter gma
  • Start date Start date
G

gma

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 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?
Click to expand...

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
 
What value is using Sum? And if you're subtracting times, you want the
result formatted as a time, not General.

Regards,
Fred
 
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
 
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 -
 
Back
Top