function to give the number of hours
 

I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?

a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5

function to give the number of hours
 

The formula for C1 would be =(B1-A1)*24

"force530" wrote:

I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?

a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5

function to give the number of hours
 

On Thu, 21 Sep 2006 13:01:02 -0700, force530
wrote:

I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?

a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5

With the data entered as above but with no double quote marks:

C1: =(B1-A1)*24

Format as General or Number with desired number of decimal places
--ron

function to give the number of hours
 

Thanks to both of you ... it worked.

"Ron Rosenfeld" wrote:

On Thu, 21 Sep 2006 13:01:02 -0700, force530
wrote:

I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?

a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5

With the data entered as above but with no double quote marks:

C1: =(B1-A1)*24

Format as General or Number with desired number of decimal places
--ron