how do i calculate the number of hours between 11:00 am & 4:00 pm
 

I need a formula or function that will calculate the number of hours between
11:00 am and 4:00 pm = 5 hours.

Thanks, Connie Smith

how do i calculate the number of hours between 11:00 am & 4:00 pm
 

=int((B1-A1)*24)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Connie" wrote in message
...
I need a formula or function that will calculate the number of hours
between
11:00 am and 4:00 pm = 5 hours.

Thanks, Connie Smith

how do i calculate the number of hours between 11:00 am & 4:00 pm
 

Hi

With end time in B1 and start time in A1 try
=B1-A1
Format the cell FormatCellsNumberCustom hh:mm

If you want to sum all of the resulting values, then that cell would
need to be formatted at [h]:mm to allow it to total past 24 hours.

--
Regards

Roger Govier


"Connie" wrote in message
...
I need a formula or function that will calculate the number of hours
between
11:00 am and 4:00 pm = 5 hours.

Thanks, Connie Smith

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?

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?