Thread: how do i calculate the number of hours between 11:00 am & 4:00 pm
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default how do i calculate the number of hours between 11:00 am & 4:00 pm
The INT function will return an integer value. If you want to display
fractions of an hour then just remove that and format the cell as
number with 2 dp, i.e.:

=(B1-A1)*24

Hope Bob doesn't mind me taking this up - he's probably in bed by now
!! <bg

Pete

nospam wrote:

Bob Phillips wrote:
=int((B1-A1)*24)

I tried this with 9:45 AM start time and 12:00 PM end time and it
calculates 2 hrs not 2.25. Any way to make it do that?

Reply With QuoteReply With Quote