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

Hi Jim

Sure. With start time in A1 and end time in B1:
=(B1-A1+(B1<A1))*24
Format the result cell as decimal number.

HTH. best wishes Harald

"gormanj" <[email protected]> skrev i melding
news:[email protected]...
> 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