Calculate the difference in date/time formatted cells
in [General]
|
Prev: Is there a way to have an excel read only auto refresh after save
Next: how do I save my name as the creater of a workbook
From: Longhorn1972 on 14 May 2010 11:13 I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30
From: Mike H on 14 May 2010 11:24 Hi, With this in A1 and b1 15/05/2010 10:00 16/05/2010 11:30 formula =B1-A1 Format the formula cell as dd hh:mm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Longhorn1972" wrote: > I need to know how to find the difference in time in two cells with a > date/time format of 05/01 04:30
From: Per Jessen on 14 May 2010 11:25 Just subtract the two cells and format the formula cell as custom [h]: mm =A2-A1 Regards, Per "Longhorn1972" <Longhorn1972(a)discussions.microsoft.com> skrev i meddelelsen news:2ED731EA-DF20-474A-BF61-2B22A9458767(a)microsoft.com... > I need to know how to find the difference in time in two cells with a > date/time format of 05/01 04:30
From: "David Biddulph" groups [at] on 14 May 2010 13:30 OK until you get beyond 31 days, I think you'll find. -- David Biddulph "Mike H" <MikeH(a)discussions.microsoft.com> wrote in message news:1ED1AA9A-C665-4346-9596-261FD2FC5BC5(a)microsoft.com... > Hi, > > With this in A1 and b1 > > 15/05/2010 10:00 16/05/2010 11:30 > > formula > > =B1-A1 > > Format the formula cell as dd hh:mm > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Longhorn1972" wrote: > >> I need to know how to find the difference in time in two cells with a >> date/time format of 05/01 04:30
From: Mike H on 14 May 2010 14:43
Yes, absolutely correct David. I had this mindset of 1 day and a few hours. Thanks for the correction. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "David Biddulph" wrote: > OK until you get beyond 31 days, I think you'll find. > -- > David Biddulph > > > "Mike H" <MikeH(a)discussions.microsoft.com> wrote in message > news:1ED1AA9A-C665-4346-9596-261FD2FC5BC5(a)microsoft.com... > > Hi, > > > > With this in A1 and b1 > > > > 15/05/2010 10:00 16/05/2010 11:30 > > > > formula > > > > =B1-A1 > > > > Format the formula cell as dd hh:mm > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "Longhorn1972" wrote: > > > >> I need to know how to find the difference in time in two cells with a > >> date/time format of 05/01 04:30 > > > . > |