View Single Post
  #2   Report Post  
Search33
 
Posts: n/a
Default How do I calculate hours in Excel

You should be able to just use a simple subtraction
for example, A1=9 am A2=12 pm A3=A2-A1 gives the result in A3 as 3:00 AM
you can then format A3 as custom and put h. This should give you 3

"Dragonrana" wrote:

I have a start date and an end date.What I need is to give the difference in
hours? How do I do that?

i.e. 9:00AM (Start Date)
12:00 PM (End Date)

Result : 3 hours

Thanks.