How do I find the amount of hours between times?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calcuate the difference between two times in tenths of a mi 1
#VALUE error add'g formulas 1
Number of hours between now and selected date 5
Find time difference and display it in hours 1
how do I change time data to numerical result 1
why is answer rounded up? 1
Formula to calculate elapsed time between certain dates and times 6
Hours between to two times 3

Top