How do I find the amount of hours between times?

G

gormanj

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
 
H

Harald Staff

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
 
Top