View Single Post
  #1   Report Post  
gormanj
 
Posts: n/a
Default How do I find the amount of hours between times?

I am creating a costed roster spread sheet. I would like to be able to
calculate amount of hours between entered times and result be displayed in
decimal number format i.e. In: 8:00am Out: 2:30pm Result: 6.5
Or........ In: 8:00 Out: 14:30 Result: 6.5
Is this possible in excel? If so how?

Thanks
Jim Gorman