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" skrev i melding
...
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