Thread: how do i calculate the number of hours between 11:00 am & 4:00 pm
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nospam nospam is offline
external usenet poster
  
Posts: 6
Default how do i calculate the number of hours between 11:00 am & 4:00pm
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