calculating clock times
in [Functions]
|
From: FSt1 on 7 Mar 2010 17:19 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" <FSt1(a)discussions.microsoft.com> wrote in message > news:B5DA1686-75B9-4111-87B0-4A5F5ED17B12(a)microsoft.com... > > 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? > > . >
From: FSt1 on 7 Mar 2010 17:21 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" <FSt1(a)discussions.microsoft.com> wrote in message > news:B5DA1686-75B9-4111-87B0-4A5F5ED17B12(a)microsoft.com... > > 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? > > > . >
From: gma on 8 Mar 2010 12:59
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 <gma(a)mircosoft.com> 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 > > . > |