calculate hours
in [Functions]
|
Prev: Using Data Validation via an array to stop manual entries - possib
Next: is there a simpler way to do this formula?
From: gma on 1 Mar 2010 16:59 how do you calculate hours i.e. 3:45am-11:15am = ______hrs?
From: Glenn on 1 Mar 2010 17:03 gma wrote: > how do you calculate hours i.e. > 3:45am-11:15am = ______hrs? Look here: http://www.cpearson.com/excel/datearith.htm
From: JLatham on 1 Mar 2010 17:33 Assuming earlier time in A14 (3:45 am) and later time in B14 (11:15 am), then in another cell = B14-A14 and now the trick: in that cell use Format --> Cells and go down to custom and use [h]:mm:ss to give you the result in hours minutes and seconds rather than as a time of day. "gma" wrote: > how do you calculate hours i.e. > 3:45am-11:15am = ______hrs?
From: Fred Smith on 1 Mar 2010 19:38 The answer is negative 8 hours. But Excel cannot display negative times. If this is what you actually want to do, post back, and we'll give you some options. If you really meant 11:15 - 3:15, it's simple subtraction: =a2-a1 Format as a time. Regards, Fred "gma" <gma(a)mircosoft.com> wrote in message news:9D88C40A-F53E-42DA-8FCA-D13832A24EF7(a)microsoft.com... > how do you calculate hours i.e. > 3:45am-11:15am = ______hrs?
From: "David Biddulph" groups [at] on 2 Mar 2010 03:57
=(A2-A1)*24 and format as General or Number, if you want the answer in decimal hours. -- David Biddulph "gma" <gma(a)mircosoft.com> wrote in message news:9D88C40A-F53E-42DA-8FCA-D13832A24EF7(a)microsoft.com... > how do you calculate hours i.e. > 3:45am-11:15am = ______hrs? |