how do you calculate hours i.e.
3:45am-11:15am = ______hrs?

gma wrote:
how do you calculate hours i.e.
3:45am-11:15am = ______hrs?


Look he

http://www.cpearson.com/excel/datearith.htm

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?

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" wrote in message
...
how do you calculate hours i.e.
3:45am-11:15am = ______hrs?

=(A2-A1)*24 and format as General or Number, if you want the answer in
decimal hours.
--
David Biddulph


"gma" wrote in message
...
how do you calculate hours i.e.
3:45am-11:15am = ______hrs?